{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["gl. til nyt niveau","reguleringsprocenter","Lønark","Forside","Omregner","Omregningstabel ","Tillæg_trin","Tillæg_kr","Samlet_omk","Tid op_ned"],"not_rendered":{"charts":0,"images":9,"macros":1,"external_links":0,"defined_names":75,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"gl. til nyt niveau","index":0,"n_rows":395,"n_cols":6,"rows_kept":395,"cut":false,"hidden":true,"merged":[]}
[null,1.3980790000000001]
[null,null,null,"Nyt grundbeløb","Nyt grundbeløb"]
["Grundbeløb pr. 1/10-1984","I alt pr. 1. april 1999 inkl. %regulering",null,"pr. 31/3-2000","pr. 31/3-2000"]
[null,null,null,"ekskl. afrunding","inkl. afrunding"]
[null,null,null,null,null,"beløb"]
[null,"pr. gang/år","pr. måned",null,null,"+/-"]
[1.63,{"$f":"IF(A7<1000,$B$1*A7,ROUND($B$1*A7,0))","v":2.2788687699999999},null,{"$f":"B7","v":2.2788687699999999},{"$f":"IF(D7<1000,D7,ROUND(D7,-2))","v":2.2788687699999999}]
[5,6.9903950000000004,null,{"$f":"B8","v":6.9903950000000004},6.9903950000000004]
[5.8,8.1088582000000002,null,8.1088582000000002,8.1088582000000002]
[9,12.582711,null,12.582711,12.582711]
[10.5,14.6798295,null,14.6798295,14.6798295]
[12.22,17.084525380000002,null,17.084525380000002,17.084525380000002]
[12.65,17.68569935,null,17.68569935,17.68569935]
[13.39,18.720277810000002,null,18.720277810000002,18.720277810000002]
[13.75,19.22358625,null,19.22358625,19.22358625]
[14.46,20.216222340000002,null,20.216222340000002,20.216222340000002]
[15.2,21.2508008,null,21.2508008,21.2508008]
[15.5,21.6702245,null,21.6702245,21.6702245]
[17,23.767343,null,23.767343,23.767343]
[18.5,25.864461500000001,null,25.864461500000001,25.864461500000001]
[19,26.563501000000002,null,26.563501000000002,26.563501000000002]
[21,29.359659000000001,null,29.359659000000001,29.359659000000001]
[23,32.155816999999999,null,32.155816999999999,32.155816999999999]
[24.97,34.910032630000003,null,34.910032630000003,34.910032630000003]
[28,39.146212000000006,null,39.146212000000006,39.146212000000006]
[30,41.942370000000004,null,41.942370000000004,41.942370000000004]
[33.29,46.542049910000003,null,46.542049910000003,46.542049910000003]
[42,58.719318000000001,null,58.719318000000001,58.719318000000001]
[61.26,85.646319540000007,null,85.646319540000007,85.646319540000007]
[62,86.680897999999999,null,86.680897999999999,86.680897999999999]
[68.319999999999993,95.516757279999993,null,95.516757279999993,95.516757279999993]
[75.13,105.03767526999999,null,105.03767526999999,105.03767526999999]
[80.38,112.37759002,null,112.37759002,112.37759002]
[136.63999999999999,191.03351455999999,null,{"$f":"B34","v":191.03351455999999},191.03351455999999]
[143.99,201.30939521000002,null,{"$f":"B35","v":201.30939521000002},201.30939521000002]
[150.61000000000001,210.56467819000002,null,210.56467819000002,210.56467819000002]
[164,229.28495600000002,null,229.28495600000002,229.28495600000002]
[170,237.67343000000002,null,237.67343000000002,237.67343000000002]
[190,265.63501000000002,null,265.63501000000002,{"$f":"IF(D39<1000,D39,ROUND(D39,-2))","v":265.63501000000002}]
[195,272.625405,null,272.625405,272.625405]
[202,282.41195800000003,null,282.41195800000003,282.41195800000003]
[260,363.50054,null,363.50054,363.50054]
[278,388.66596200000004,null,388.66596200000004,388.66596200000004]
[300.83999999999997,420.59808635999997,null,420.59808635999997,420.59808635999997]
[350,489.32765000000001,null,489.32765000000001,489.32765000000001]
[380,531.27002000000005,null,531.27002000000005,531.27002000000005]
[398.95,557.76361704999999,null,557.76361704999999,557.76361704999999]
[420,587.19317999999998,null,587.19317999999998,587.19317999999998]
[465,650.10673500000007,null,650.10673500000007,650.10673500000007]
[490,685.05871000000002,null,685.05871000000002,685.05871000000002]
[502,701.83565800000008,null,701.83565800000008,701.83565800000008]
[559,781.526161,null,781.526161,781.526161]
[597,834.65316300000006,null,834.65316300000006,834.65316300000006]
[700,978.65530000000001,{"$f":"VALUE(B54)/12","v":81.554608333333334},978.65530000000001,{"$f":"IF(D54<1000,D54,ROUND(D54,-2))","v":978.65530000000001},{"$f":"E54-D54","v":0}]
[750,1048.55925,87.379937499999997,1048.55925,{"$f":"IF(D55<1000,D55,ROUND(D55,-2))","v":1000},-48.55925000000002]
[800,1118.4632000000001,93.205266666666674,1118.4632000000001,{"$f":"IF(D56<1000,D56,ROUND(D56,-2))","v":1100},-18.463200000000143]
[842.75,1178.23107725,98.185923104166662,1178.23107725,1200,21.768922750000002]
[868,1213.5325720000001,101.12771433333334,1213.5325720000001,1200,-13.532572000000073]
[917.14,1282.23417406,106.85284783833333,{"$f":"B59","v":1282.23417406},1300,17.765825940000013]
[920,1286.2326800000001,107.18605666666667,1286.2326800000001,1300,13.767319999999927]
[925,1293.2230750000001,107.76858958333334,1293.2230750000001,1300,6.776924999999892]
[950,{"$f":"IF(A62<1000,$B$1*A62,ROUND($B$1*A62,0))","v":1328.1750500000001},110.68125416666668,1328.1750500000001,1300,-28.175050000000056]
[1000,{"$f":"IF(A63<1000,$B$1*A63,ROUND($B$1*A63,0))","v":1398},116.5,1398,1400,2]
[1050,{"$f":"IF(A64<1000,$B$1*A64,ROUND($B$1*A64,0))","v":1468},122.33333333333333,1468,1500,32]
[1100,{"$f":"IF(A65<1000,$B$1*A65,ROUND($B$1*A65,0))","v":1538},128.16666666666666,1538,1500,-38]
[1200,1678,139.83333333333334,1678,1700,22]
[1245,1741,145.08333333333334,{"$f":"B67","v":1741},1700,{"$f":"E67-D67","v":-41}]
[1300,1818,151.5,1818,1800,-18]
[1327,1855,154.58333333333334,1855,1900,45]
[1400,1957,163.08333333333334,1957,2000,43]
[1500,2097,174.75,2097,2100,3]
[1600,2237,186.41666666666666,2237,2200,-37]
[1700,2377,198.08333333333334,2377,2400,23]
[1750,2447,203.91666666666666,2447,2400,-47]
[1800,2517,209.75,2517,2500,-17]
[1900,2656,221.33333333333334,2656,2700,44]
[2000,2796,233,2796,2800,4]
[2050,2866,238.83333333333334,2866,2900,34]
[2100,2936,244.66666666666666,2936,2900,-36]
[2145,2999,249.91666666666666,2999,3000,1]
[2150,3006,250.5,3006,3000,-6]
[2200,3076,256.33333333333331,3076,3100,24]
[2300,3216,268,3216,3200,-16]
[2400,3355,279.58333333333331,3355,3400,45]
[2450,3425,285.41666666666669,3425,3400,-25]
[2500,3495,291.25,3495,3500,5]
[2600,3635,302.91666666666669,3635,3600,-35]
[2700,3775,314.58333333333331,3775,3800,25]
[2730,3817,318.08333333333331,3817,3800,-17]
[2800,3915,326.25,3915,3900,-15]
[2900,4054,337.83333333333331,4054,4100,46]
[3000,4194,349.5,4194,4200,6]
[3100,4334,361.16666666666669,4334,4300,-34]
[3200,4474,372.83333333333331,4474,4500,26]
[3300,4614,384.5,4614,4600,-14]
[3400,4753,396.08333333333331,4753,4800,47]
[3500,4893,407.75,4893,4900,7]
[3600,5033,419.41666666666669,5033,5000,-33]
[3700,5173,431.08333333333331,5173,5200,27]
[3800,5313,442.75,5313,5300,-13]
[3900,5453,454.41666666666669,5453,5500,47]
[4000,5592,466,5592,5600,8]
[4100,5732,477.66666666666669,5732,5700,-32]
[4200,5872,489.33333333333331,5872,5900,28]
[4226.1000000000004,5908,492.33333333333331,5908,5900,-8]
[4300,6012,501,6012,6000,-12]
[4400,6152,512.66666666666663,6152,6200,48]
[4430,6193,516.08333333333337,6193,6200,7]
[4500,6291,524.25,6291,6300,9]
[4600,6431,535.91666666666663,6431,6400,-31]
[4700,6571,547.58333333333337,6571,6600,29]
[1770,2475,206.25,2475,2500,25]
[4800,6711,559.25,6711,6700,-11]
[4900,6851,570.91666666666663,6851,6900,49]
[4930,6893,574.41666666666663,6893,6900,7]
[5000,6990,582.5,6990,7000,10]
[5100,7130,594.16666666666663,7130,7100,-30]
[5200,7270,{"$f":"VALUE(B118)/12","v":605.83333333333337},7270,7300,30]
[5300,7410,617.5,7410,7400,-10]
[5318,7435,619.58333333333337,7435,{"$f":"IF(D120<1000,D120,ROUND(D120,-2))","v":7400},-35]
[5400,7550,629.16666666666663,7550,7600,50]
[5420.91,7579,631.58333333333337,7579,7600,21]
[5500,7689,640.75,{"$f":"B123","v":7689},7700,{"$f":"E123-D123","v":11}]
[5600,7829,652.41666666666663,7829,7800,-29]
[5700,7969,664.08333333333337,7969,8000,31]
[5770.78,8068,672.33333333333337,8068,8100,32]
[5800,8109,675.75,8109,8100,-9]
[5900,8249,687.41666666666663,8249,8200,-49]
[6000,{"$f":"IF(A129<1000,$B$1*A129,ROUND($B$1*A129,0))","v":8388},699,8388,8400,12]
[6078,8498,708.16666666666663,8498,8500,2]
[6100,8528,710.66666666666663,8528,8500,-28]
[6140,8584,715.33333333333337,8584,8600,16]
[6200,8668,722.33333333333337,8668,8700,32]
[6290.15,8794,732.83333333333337,8794,8800,6]
[6300,8808,734,8808,8800,-8]
[6400,8948,745.66666666666663,8948,8900,-48]
[6500,9088,757.33333333333337,9088,9100,12]
[6600,9227,768.91666666666663,9227,9200,-27]
[6700,9367,780.58333333333337,9367,9400,33]
[6743.33,9428,785.66666666666663,9428,9400,-28]
[6800,9507,792.25,9507,9500,-7]
[6900,9647,803.91666666666663,9647,9600,-47]
[7000,9787,815.58333333333337,9787,9800,13]
[7100,9926,827.16666666666663,9926,9900,-26]
[7200,10066,838.83333333333337,10066,10100,34]
[7300,10206,850.5,10206,10200,-6]
[7335.23,10255,854.58333333333337,10255,10300,45]
[7400,10346,862.16666666666663,10346,10300,-46]
[7500,10486,873.83333333333337,10486,10500,14]
[7600,10625,885.41666666666663,10625,10600,-25]
[7700,10765,897.08333333333337,10765,10800,35]
[7800,10905,908.75,10905,10900,-5]
[7900,11045,920.41666666666663,11045,11000,-45]
[8000,11185,932.08333333333337,11185,11200,15]
[8100,11324,943.66666666666663,11324,11300,-24]
[8200,11464,955.33333333333337,11464,11500,36]
[8300,11604,967,11604,11600,-4]
[8400,11744,978.66666666666663,11744,11700,-44]
[8500,11884,990.33333333333337,11884,11900,16]
[8600,12023,1001.9166666666666,12023,12000,-23]
[8700,12163,1013.5833333333334,12163,12200,37]
[8800,12303,1025.25,12303,12300,-3]
[8900,12443,1036.9166666666667,12443,12400,-43]
[9000,12583,1048.5833333333333,12583,12600,17]
[9100,12723,1060.25,12723,12700,-23]
[9200,12862,1071.8333333333333,12862,12900,38]
[9300,13002,1083.5,13002,13000,-2]
[9400,13142,1095.1666666666667,13142,13100,-42]
[9450,13212,1101,13212,13200,-12]
[9500,13282,1106.8333333333333,13282,13300,18]
[9600,13422,1118.5,13422,13400,-22]
[9700,13561,1130.0833333333333,13561,13600,39]
[9800,13701,1141.75,13701,13700,-1]
[9900,13841,1153.4166666666667,13841,13800,-41]
[10000,13981,1165.0833333333333,13981,14000,19]
[10600,14820,1235,14820,14800,-20]
[10800,15099,1258.25,15099,15100,1]
[11000,15379,1281.5833333333333,15379,15400,21]
[11200,15658,1304.8333333333333,15658,15700,42]
[11300,15798,1316.5,15798,15800,2]
[11500,16078,1339.8333333333333,16078,16100,22]
[11600,16218,{"$f":"VALUE(B182)/12","v":1351.5},16218,16200,-18]
[11700,16358,1363.1666666666667,16358,16400,42]
[11800,16497,1374.75,16497,{"$f":"IF(D184<1000,D184,ROUND(D184,-2))","v":16500},3]
[11900,16637,1386.4166666666667,16637,16600,-37]
[12000,16777,1398.0833333333333,16777,16800,23]
[12100,16917,1409.75,{"$f":"B187","v":16917},16900,{"$f":"E187-D187","v":-17}]
[12200,17057,1421.4166666666667,17057,17100,43]
[12300,17196,1433,17196,17200,4]
[12400,17336,1444.6666666666667,17336,17300,-36]
[12500,17476,1456.3333333333333,17476,17500,24]
[12600,17616,1468,17616,17600,-16]
[12700,{"$f":"IF(A193<1000,$B$1*A193,ROUND($B$1*A193,0))","v":17756},1479.6666666666667,17756,17800,44]
[12800,17895,1491.25,17895,17900,5]
[12900,18035,1502.9166666666667,18035,18000,-35]
[13000,18175,1514.5833333333333,18175,18200,25]
[13200,18455,1537.9166666666667,18455,18500,45]
[13400,18734,1561.1666666666667,18734,18700,-34]
[13500,18874,1572.8333333333333,18874,18900,26]
[13700,19154,1596.1666666666667,19154,19200,46]
[14000,19573,1631.0833333333333,19573,19600,27]
[14300,19993,1666.0833333333333,19993,20000,7]
[14500,20272,1689.3333333333333,20272,20300,28]
[14700,20552,1712.6666666666667,20552,20600,48]
[14800,20692,1724.3333333333333,20692,20700,8]
[14900,20831,1735.9166666666667,20831,20800,-31]
[15000,20971,1747.5833333333333,20971,21000,29]
[15100,21111,1759.25,21111,21100,-11]
[15200,21251,1770.9166666666667,21251,21300,49]
[15500,21670,1805.8333333333333,21670,21700,30]
[15700,21950,1829.1666666666667,21950,22000,50]
[15900,22229,1852.4166666666667,22229,22200,-29]
[16000,22369,1864.0833333333333,22369,22400,31]
[16100,22509,1875.75,22509,22500,-9]
[16200,22649,1887.4166666666667,22649,22600,-49]
[16700,23348,1945.6666666666667,23348,23300,-48]
[16800,23488,1957.3333333333333,23488,23500,12]
[16900,23628,1969,23628,23600,-28]
[17000,23767,1980.5833333333333,23767,23800,33]
[17100,23907,1992.25,23907,23900,-7]
[17600,24606,2050.5,24606,24600,-6]
[17700,24746,2062.1666666666665,24746,24700,-46]
[18000,25165,2097.0833333333335,25165,25200,35]
[18200,25445,2120.4166666666665,25445,25400,-45]
[18300,25585,2132.0833333333335,25585,25600,15]
[18600,26004,2167,26004,26000,-4]
[18700,26144,2178.6666666666665,26144,26100,-44]
[18800,26284,2190.3333333333335,{"$f":"B228","v":26284},26300,{"$f":"E228-D228","v":16}]
[18900,26424,2202,26424,26400,-24]
[19000,26564,2213.6666666666665,26564,26600,36]
[19100,26703,2225.25,26703,26700,-3]
[19400,27123,2260.25,27123,27100,-23]
[19500,27263,2271.9166666666665,27263,27300,37]
[19600,27402,2283.5,27402,27400,-2]
[19700,27542,2295.1666666666665,27542,27500,-42]
[20000,27962,2330.1666666666665,27962,28000,38]
[20300,28381,2365.0833333333335,28381,28400,19]
[20400,28521,2376.75,28521,28500,-21]
[20500,28661,2388.4166666666665,28661,28700,39]
[20800,29080,2423.3333333333335,29080,29100,20]
[20900,29220,2435,29220,29200,-20]
[21100,29499,2458.25,29499,29500,1]
[21300,29779,2481.5833333333335,29779,29800,21]
[21900,30618,2551.5,30618,30600,-18]
[22000,30758,2563.1666666666665,30758,30800,42]
[22200,31037,{"$f":"VALUE(B246)/12","v":2586.4166666666665},31037,31000,-37]
[22400,31317,2609.75,31317,31300,-17]
[22500,31457,2621.4166666666665,31457,{"$f":"IF(D248<1000,D248,ROUND(D248,-2))","v":31500},43]
[22600,31597,2633.0833333333335,31597,31600,3]
[22900,32016,2668,32016,32000,-16]
[23000,32156,2679.6666666666665,32156,32200,44]
[23200,32435,2702.9166666666665,32435,32400,-35]
[23300,32575,2714.5833333333335,32575,32600,25]
[23400,32715,2726.25,32715,32700,-15]
[23500,32855,2737.9166666666665,32855,32900,45]
[23600,32995,2749.5833333333335,32995,33000,5]
[23700,{"$f":"IF(A257<1000,$B$1*A257,ROUND($B$1*A257,0))","v":33134},2761.1666666666665,33134,33100,-34]
[23800,33274,2772.8333333333335,33274,33300,26]
[23900,33414,2784.5,33414,33400,-14]
[24000,33554,2796.1666666666665,33554,33600,46]
[24500,34253,2854.4166666666665,34253,34300,47]
[24900,34812,2901,34812,34800,-12]
[25000,34952,2912.6666666666665,34952,35000,48]
[25200,35232,2936,35232,35200,-32]
[25400,35511,2959.25,35511,35500,-11]
[25700,35931,2994.25,35931,35900,-31]
[26000,36350,3029.1666666666665,36350,36400,50]
[26300,36769,3064.0833333333335,36769,36800,31]
[26600,37189,3099.0833333333335,37189,37200,11]
[26700,37329,3110.75,37329,37300,-29]
[26900,37608,3134,37608,37600,-8]
[27000,37748,3145.6666666666665,37748,37700,-48]
[27100,37888,3157.3333333333335,37888,37900,12]
[27600,38587,3215.5833333333335,38587,38600,13]
[27700,38727,3227.25,38727,38700,-27]
[28000,39146,3262.1666666666665,39146,39100,-46]
[28100,39286,3273.8333333333335,39286,39300,14]
[29000,40544,3378.6666666666665,40544,40500,-44]
[29100,40684,3390.3333333333335,40684,40700,16]
[29200,40824,3402,40824,40800,-24]
[29300,40964,3413.6666666666665,40964,41000,36]
[29400,41104,3425.3333333333335,41104,41100,-4]
[29900,41803,3483.5833333333335,41803,41800,-3]
[30000,41942,3495.1666666666665,41942,41900,-42]
[30200,42222,3518.5,42222,42200,-22]
[30500,42641,3553.4166666666665,42641,42600,-41]
[30700,42921,3576.75,42921,42900,-21]
[30800,43061,3588.4166666666665,43061,43100,39]
[31800,44459,3704.9166666666665,44459,44500,41]
[32000,44739,3728.25,44739,44700,-39]
[32100,44878,3739.8333333333335,44878,44900,22]
[32500,45438,3786.5,{"$f":"B292","v":45438},45400,{"$f":"E292-D292","v":-38}]
[33000,46137,3844.75,46137,46100,-37]
[33300,46556,3879.6666666666665,46556,46600,44]
[34200,47814,3984.5,47814,47800,-14]
[34300,47954,3996.1666666666665,47954,48000,46]
[34700,48513,4042.75,48513,48500,-13]
[35000,48933,4077.75,{"$f":"B298","v":48933},48900,{"$f":"E298-D298","v":-33}]
[35100,49073,4089.4166666666665,49073,49100,27]
[35200,49212,4101,49212,49200,-12]
[35400,49492,4124.333333333333,49492,49500,8]
[36500,51030,4252.5,51030,51000,-30]
[36700,51309,4275.75,51309,51300,-9]
[37000,51729,4310.75,51729,51700,-29]
[38200,53407,4450.583333333333,53407,53400,-7]
[38900,54385,4532.083333333333,54385,54400,15]
[39200,54805,4567.083333333333,54805,54800,-5]
[40300,56343,4695.25,56343,56300,-43]
[40900,57181,4765.083333333333,57181,57200,19]
[41600,58160,{"$f":"VALUE(B310)/12","v":4846.666666666667},58160,58200,40]
[42000,58719,4893.25,58719,58700,-19]
[42700,59698,4974.833333333333,59698,{"$f":"IF(D312<1000,D312,ROUND(D312,-2))","v":59700},2]
[43300,60537,5044.75,60537,60500,-37]
[43500,60816,5068,60816,60800,-16]
[44000,61515,5126.25,61515,61500,-15]
[44100,61655,5137.916666666667,61655,61700,45]
[44900,62774,5231.166666666667,62774,62800,26]
[45700,63892,5324.333333333333,63892,63900,8]
[46000,64312,5359.333333333333,64312,64300,-12]
[46500,65011,5417.583333333333,65011,65000,-11]
[47000,{"$f":"IF(A321<1000,$B$1*A321,ROUND($B$1*A321,0))","v":65710},5475.833333333333,65710,65700,-10]
[47200,65989,5499.083333333333,65989,66000,11]
[47700,66688,5557.333333333333,66688,66700,12]
[48000,67108,5592.333333333333,67108,67100,-8]
[48600,67947,5662.25,67947,67900,-47]
[48800,68226,5685.5,68226,68200,-26]
[49900,69764,5813.666666666667,69764,69800,36]
[50000,69904,5825.333333333333,69904,69900,-4]
[51300,71721,5976.75,71721,71700,-21]
[52000,72700,6058.333333333333,72700,72700,0]
[53000,74098,6174.833333333333,74098,74100,2]
[53900,75356,6279.666666666667,75356,75400,44]
[55000,76894,6407.833333333333,76894,76900,6]
[56700,79271,6605.916666666667,79271,79300,29]
[56800,79411,6617.583333333333,79411,79400,-11]
[57000,79691,6640.916666666667,79691,79700,9]
[58700,82067,6838.916666666667,82067,82100,33]
[58800,82207,6850.583333333333,82207,82200,-7]
[59000,82487,6873.916666666667,82487,82500,13]
[59900,83745,6978.75,83745,83700,-45]
[60000,83885,6990.416666666667,83885,83900,15]
[62300,87100,7258.333333333333,87100,87100,0]
[63000,88079,7339.916666666667,88079,88100,21]
[63300,88498,7374.833333333333,88498,88500,2]
[63700,89058,7421.5,89058,89100,42]
[65000,90875,7572.916666666667,90875,90900,25]
[66100,92413,7701.083333333333,92413,92400,-13]
[67000,93671,7805.916666666667,93671,93700,29]
[69600,97306,8108.833333333333,97306,97300,-6]
[70400,98425,8202.0833333333339,98425,98400,-25]
[70800,98984,8248.6666666666661,98984,99000,16]
[71000,99264,8272,99264,99300,36]
[71700,100242,8353.5,100242,100200,-42]
[73400,102619,8551.5833333333339,102619,102600,-19]
[73500,102759,8563.25,102759,102800,41]
[78900,110308,9192.3333333333339,110308,110300,-8]
[80600,112685,9390.4166666666661,112685,112700,15]
[82200,114922,9576.8333333333339,114922,114900,-22]
[82600,115481,9623.4166666666661,115481,115500,19]
[82900,115901,9658.4166666666661,115901,115900,-1]
[83300,116460,9705,116460,116500,40]
[87000,121633,10136.083333333334,{"$f":"B362","v":121633},121600,{"$f":"E362-D362","v":-33}]
[88100,123171,10264.25,123171,123200,29]
[90600,126666,10555.5,126666,126700,34]
[93200,130301,10858.416666666666,130301,130300,-1]
[93900,131280,10940,131280,131300,20]
[94400,131979,10998.25,131979,132000,21]
[95300,133237,11103.083333333334,133237,133200,-37]
[96200,134495,11207.916666666666,134495,134500,5]
[102700,143583,11965.25,143583,143600,17]
[102800,143723,11976.916666666666,143723,143700,-23]
[104100,145540,12128.333333333334,145540,145500,-40]
[105600,147637,12303.083333333334,147637,147600,-37]
[106100,148336,{"$f":"VALUE(B374)/12","v":12361.333333333334},148336,148300,-36]
[109400,152950,12745.833333333334,152950,153000,50]
[110000,153789,12815.75,153789,{"$f":"IF(D376<1000,D376,ROUND(D376,-2))","v":153800},11]
[116200,162457,13538.083333333334,162457,162500,43]
[117300,163995,13666.25,163995,164000,5]
[117400,164134,13677.833333333334,164134,164100,-34]
[118000,164973,13747.75,164973,165000,27]
[118300,165393,13782.75,165393,165400,7]
[123400,172523,14376.916666666666,172523,172500,-23]
[124700,174340,14528.333333333334,174340,174300,-40]
[127100,177696,14808,177696,177700,4]
[129100,{"$f":"IF(A385<1000,$B$1*A385,ROUND($B$1*A385,0))","v":180492},15041,180492,180500,8]
[129800,181471,15122.583333333334,181471,181500,29]
[130900,183009,15250.75,183009,183000,-9]
[131900,184407,15367.25,184407,184400,-7]
[133400,186504,15542,186504,186500,-4]
[139400,194892,16241,194892,194900,8]
[140900,196989,16415.75,196989,197000,11]
[141600,197968,16497.333333333332,197968,198000,32]
[145000,202721,16893.416666666668,202721,202700,-21]
[146600,204958,17079.833333333332,204958,205000,42]
[147700,206496,17208,206496,206500,4]

{"sheet":"reguleringsprocenter","index":1,"n_rows":29,"n_cols":4,"rows_kept":29,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Reguleringsprocenter",null,"pensionsudbygning"]
[null,"Valgt:",{"$f":"VLOOKUP(Forside!K11,reguleringsprocenter!B4:D15,2,TRUE)","v":1.456933}]
[null,"2019-04-01",1.3772530000000001,1]
[null,"2019-10-01",1.3908609999999999,1]
[null,"2020-01-01",1.4124110000000001,1]
[null,"2020-04-01",1.4177979999999999,1]
[null,"2020-10-01",1.4285110000000001,1]
[null,"2021-04-01",1.442796,1]
[null,"2021-10-01",1.456933,1]
[null,"2022-04-01",1.456933,1]
[null,"2022-10-01",1.4940180000000001,1]
[null,"2023-04-01",1.4983040000000001,1]
[null,null,null,1]
[]
[]
[]
[null,"Liste, opslag niveauer"]
[]
[null,"2023-04-01"]
[null,"2022-10-01"]
[null,"2022-04-01"]
[null,"2021-10-01"]
[null,"2021-04-01"]
[null,"2020-10-01"]
[null,"2020-04-01"]
[null,"2020-01-01"]
[null,"2019-10-01"]
[null,"2019-04-01"]

{"sheet":"Lønark","index":2,"n_rows":71,"n_cols":88,"rows_kept":71,"cut":false,"hidden":true,"merged":[]}
[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56]
["Næstved",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Løn","Årsløn",null,null,"Ureguleret ikke-pensionsgivende tillæg",null,null,null,"Årsløn ialt ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lavtlønsprojekt"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Løn","Årsløn",null,null,"Ureguleret ikke-pensionsgivende tillæg",null,null,null,null,null,null,null,null,null,"Områdetillæg inkl. regulering",null,null,null,null,"Årsløn ialt ",null,null,null,null,null,"Pensionsgivende løn",null,null,null,null,null,null,null,null,"Pensionsgivende løn",null,null,null,null,null,"Løn","timelønninger",null,null,null,null,null,"Løn","timelønninger + 50%",null,null,null,null,null,"Løn","søndagstillæg - 50%",null,null,null,null,null,null,"2019-03-31",0,0]
[null,"Månedsløn, løngrupper",null,null,"Lønniveau:",{"$f":"VLOOKUP(beregningsdato,regpct_tabel,1,TRUE)","v":"2022-04-01"},null,"Optrapning fra:",null,null,null,null,"Pensionsgivende løn",null,null,null,null,null,"Pensionsgivende løn, optrapning fra:",null,null,null,null,"trin","Grundsats","%-reg.","Sats","Omr 1","Omr 2","Omr 3","Omr 4",null,null,null,null,null,null,1,2,3,4,null,"Omr 0","Omr 1","Omr 2","Omr 3","Omr 4",null,"Grundsats","%-reg.","Sats",null,"Pensionsudbygningspct:",null,null,{"$f":"VLOOKUP(F4,regpct_tabel,3,FALSE)","v":1},null,"Omr 0","Omr 1","Omr 2","Omr 3","Omr 4",null,"trin","Omr 0","Omr 1","Omr 2","Omr 3","Omr 4",null,"trin","Omr 0","Omr 1","Omr 2","Omr 3","Omr 4",null,"trin","Omr 0","Omr 1","Omr 2","Omr 3","Omr 4",null,null,"2019-04-01",382,0]
[null,0,1,2,3,4,null,"0->1","1->2","2->3",null,null,0,1,2,3,4,null,"0->1","1->2","2->3","3->4",null,null,{"$f":"VLOOKUP(beregningsdato,Lavtløn,2,TRUE)","v":1035},{"$f":"valgt_regulering-1","v":0.45693300000000003},"2019-04-01","2022-04-01",{"$f":"VLOOKUP(beregningsdato,Lavtløn,3,TRUE)","v":653},null,null,null,null,null,null,null,null,{"$f":"IF(beregningsdato<40087,0,regulering)","v":0.45693300000000003},{"$f":"IF(beregningsdato<40087,0,5)","v":5},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-04-01",{"$f":"CI4+CJ5","v":1035},653]
[1,{"$f":"AQ6/12","v":17871},18123.75,18298.75,18551.666666666668,18726.583333333332,null,{"$f":"ROUND(AQ6+(AR6-AQ6)/3*faktor,0)/12","v":19101759.75},{"$f":"ROUND(AR6+(AS6-AR6)/3*faktor,0)/12","v":13231498.75},{"$f":"ROUND(AS6+(AT6-AS6)/3*faktor,0)/12","v":19114771.666666668},null,1,{"$f":"BF6/12","v":17871},18123.75,18298.75,18551.666666666668,18726.583333333332,null,{"$f":"(BF6+ROUND((BG6-BF6)/3*faktor,0))/12","v":19101759.75},{"$f":"(BG6+ROUND((BH6-BG6)/3*faktor,0))/12","v":13231498.75},{"$f":"(BH6+ROUND((BI6-BH6)/3*faktor,0))/12","v":19114771.666666668},{"$f":"(BI6+ROUND((BJ6-BI6)/3*faktor,0))/12","v":13225634.583333334},null,1,147194,{"$f":"ROUND(Y6*regulering,0)","v":67258},{"$f":"Y6+Z6","v":214452},2585,4374,6959,8748,null,2082,3523,5606,7047,null,{"$f":"ROUND(VLOOKUP($X6,$X:$AJ,(4+AL$4)+$AM$5)*(1+$AL$5),0)","v":3033},5133,8168,10267,null,{"$f":"$AA6","v":214452},{"$f":"$AA6+AL6","v":217485},219585,222620,224719,null,147194,{"$f":"AW6*regulering","v":67257.796002000003},{"$f":"ROUND(SUM(AW6:AX6),0)","v":214452},null,{"$f":"ROUND(AL6*udbygningspct,0)","v":3033},{"$f":"ROUND(AM6*udbygningspct,0)","v":5133},{"$f":"ROUND(AN6*udbygningspct,0)","v":8168},{"$f":"ROUND(AO6*udbygningspct,0)","v":10267},null,{"$f":"AY6","v":214452},{"$f":"$BF6+BA6","v":217485},{"$f":"$BF6+BB6","v":219585},222620,224719,null,1,{"$f":"AQ6/1924","v":111.46153846153847},113.03794178794179,114.12941787941789,115.70686070686071,116.79781704781705,null,1,{"$f":"AQ6/1924*1.5","v":167.19230769230771},{"$f":"AR6/1924*1.5","v":169.55691268191268},{"$f":"AS6/1924*1.5","v":171.19412681912684},{"$f":"AT6/1924*1.5","v":173.56029106029106},{"$f":"AU6/1924*1.5","v":175.19672557172558},null,1,{"$f":"AQ6/1924/2","v":55.730769230769234},56.518970893970895,57.064708939708943,57.853430353430355,58.398908523908524]
[2,18145.5,18404.5,18583.666666666668,18842.666666666668,19021.833333333332,null,19573940.5,13546383.666666666,19574378.666666668,null,2,18145.5,18404.5,18583.666666666668,18842.666666666668,19021.833333333332,null,19573940.5,13546383.666666666,19574378.666666668,13546821.833333334,null,2,149455,68291,217746,2648,4481,7128,8961,null,2133,3609,5742,7218,null,3108,5258,8366,10516,null,{"$f":"$AA7","v":217746},220854,223004,226112,228262,null,149455,{"$f":"AW7*regulering","v":68290.921515000009},{"$f":"ROUND(SUM(AW7:AX7),0)","v":217746},null,3108,5258,8366,10516,null,{"$f":"AY7","v":217746},220854,223004,226112,228262,null,2,113.17359667359668,114.78898128898129,115.9064449064449,117.52182952182952,118.63929313929314,null,2,{"$f":"AQ7/1924*1.5","v":169.76039501039503},172.18347193347194,173.85966735966736,176.28274428274426,177.95893970893971,null,2,56.586798336798338,57.394490644490645,57.953222453222452,58.760914760914758,59.319646569646572]
[3,18427.416666666668,18692.583333333332,18876.25,19141.416666666668,19325.25,null,20039836.583333332,13886444.25,20040285.416666668,null,3,18427.416666666668,18692.583333333332,18876.25,19141.416666666668,19325.25,null,20039836.583333332,13886444.25,20040285.416666668,13899477.25,null,3,151777,69352,221129,2711,4590,7301,9180,null,2184,3697,5881,7395,null,3182,5386,8568,10774,null,221129,224311,226515,229697,231903,null,151777,69351.919941,221129,null,3182,5386,8568,10774,null,221129,224311,226515,229697,231903,null,3,114.93191268191268,116.58575883575884,117.73128898128898,119.38513513513513,120.53170478170478,null,3,172.39786902286903,174.87863825363826,176.59693347193348,179.07770270270271,180.79755717255716,null,3,57.465956340956339,58.292879417879419,58.865644490644492,59.692567567567565,60.265852390852388]
[4,18717.083333333332,18988.916666666668,19177,19448.833333333332,19636.916666666668,null,20543492.916666668,14220221,20543952.833333332,null,4,18717.083333333332,18988.916666666668,19177,19448.833333333332,19636.916666666668,null,20543492.916666668,14220221,20543952.833333332,14220680.916666666,null,4,154163,70442,224605,2779,4703,7482,9405,null,2239,3788,6027,7576,null,3262,5519,8781,11038,null,224605,227867,230124,233386,235643,null,154163,70442.162079000002,224605,null,3262,5519,8781,11038,null,224605,227867,230124,233386,235643,null,4,116.73856548856548,118.43399168399168,119.60706860706861,121.30249480249481,122.47557172557173,null,4,175.10784823284823,177.65098752598752,179.4106029106029,181.95374220374219,183.71335758835758,null,4,58.369282744282742,59.216995841995839,59.803534303534306,60.651247401247403,61.237785862785863]
[5,19014.666666666668,19293.083333333332,19486,19764.416666666668,19957.083333333332,null,21040865.083333332,14585466,21041336.416666668,null,5,19014.666666666668,19293.083333333332,19486,19764.416666666668,19957.083333333332,null,21040865.083333332,14585466,21041336.416666668,14567061.083333334,null,5,156614,71562,228176,2847,4819,7666,9636,null,2293,3882,6175,7762,null,3341,5656,8997,11309,null,228176,231517,233832,237173,239485,null,156614,71562.104862000007,228176,null,3341,5656,8997,11309,null,228176,231517,233832,237173,239485,null,5,118.5945945945946,120.33108108108108,121.53430353430353,123.27079002079002,124.47245322245323,null,5,177.8918918918919,180.49662162162161,182.30145530145529,184.90618503118503,186.70867983367984,null,5,59.297297297297298,60.16554054054054,60.767151767151766,61.635395010395008,62.236226611226613]
[6,19320.75,19606.083333333332,19803.583333333332,20088.833333333332,20286.333333333332,null,21563414.083333332,14931843.583333334,21557604.833333332,null,6,19320.75,19606.083333333332,19803.583333333332,20088.833333333332,20286.333333333332,null,21563414.083333332,14931843.583333334,21557604.833333332,14932326.333333334,null,6,159135,72714,231849,2917,4937,7854,9873,null,2350,3977,6326,7953,null,3424,5794,9217,11587,null,231849,235273,237643,241066,243436,null,159135,72714.032955000002,231849,null,3424,5794,9217,11587,null,231849,235273,237643,241066,243436,null,6,120.50363825363826,122.28326403326403,123.51507276507276,125.29417879417879,126.52598752598753,null,6,180.75545738045739,183.42489604989606,185.27260914760913,187.94126819126819,189.78898128898129,null,6,60.251819126819129,61.141632016632016,61.757536382536379,62.647089397089395,63.262993762993766]
[7,19634.75,19927.083333333332,20129.583333333332,20422,20624.25,null,22092263.083333332,15309689.583333334,22099050,null,7,19634.75,19927.083333333332,20129.583333333332,20422,20624.25,null,22092263.083333332,15309689.583333334,22099050,15291308.25,null,7,161721,73896,235617,2989,5060,8049,10118,null,2408,4076,6484,8150,null,3508,5938,9447,11874,null,235617,239125,241555,245064,247491,null,161721,73895.661693000002,235617,null,3508,5938,9447,11874,null,235617,239125,241555,245064,247491,null,7,122.46205821205821,124.28534303534303,125.54833679833679,127.37214137214137,128.63357588357587,null,7,183.69308731808732,186.42801455301455,188.32250519750519,191.05821205821206,192.95036382536381,null,7,61.231029106029105,62.142671517671516,62.774168399168396,63.686070686070686,64.316787941787936]
[8,19969.333333333332,20269.25,20476.916666666668,20776.75,20984.333333333332,null,22665177.25,15700140.916666666,22659392.75,null,8,19969.333333333332,20269.25,20476.916666666668,20776.75,20984.333333333332,null,22665177.25,15700140.916666666,22659392.75,15694356.333333334,null,8,164477,75155,239632,3067,5190,8256,10379,null,2470,4181,6650,8360,null,3599,6091,9689,12180,null,239632,243231,245723,249321,251812,null,164477,75154.969041000004,239632,null,3599,6091,9689,12180,null,239632,243231,245723,249321,251812,null,8,124.54885654885655,126.41943866943868,127.71465696465697,129.58471933471932,130.87941787941787,null,8,186.82328482328484,189.629158004158,191.57198544698545,194.37707900207897,196.31912681912681,null,8,62.274428274428274,63.209719334719338,63.857328482328484,64.792359667359662,65.439708939708936]
[9,20597.5,20904.916666666668,21117.666666666668,21424.916666666668,21637.75,null,{"$f":"ROUND(AQ14+(AR14-AQ14)/3*faktor,0)/12","v":23232092.916666668},{"$f":"ROUND(AR14+(AS14-AR14)/3*faktor,0)/12","v":16084593.666666666},{"$f":"ROUND(AS14+(AT14-AS14)/3*faktor,0)/12","v":23220028.916666668},null,9,20597.5,20904.916666666668,21117.666666666668,21424.916666666668,21637.75,null,{"$f":"(BF14+ROUND((BG14-BF14)/3*faktor,0))/12","v":23232092.916666668},{"$f":"(BG14+ROUND((BH14-BG14)/3*faktor,0))/12","v":16084593.666666666},{"$f":"(BH14+ROUND((BI14-BH14)/3*faktor,0))/12","v":23220028.916666668},{"$f":"(BI14+ROUND((BJ14-BI14)/3*faktor,0))/12","v":16091405.75},null,9,169651,77519,247170,3143,5319,8461,10637,null,2532,4284,6815,8568,null,3689,6242,9929,12483,{"$f":"AR14/12","v":20904.916666666668},247170,{"$f":"ROUND($AA14+AL14,0)","v":250859},{"$f":"$AA14+AM14","v":253412},{"$f":"$AA14+AN14","v":257099},{"$f":"$AA14+AO14","v":259653},null,169651,77519.140383000005,247170,null,3689,6242,9929,12483,null,247170,250859,253412,257099,259653,null,9,128.46673596673597,130.38409563409564,131.71101871101871,133.62733887733887,134.95478170478171,null,9,192.70010395010394,195.57614345114348,197.56652806652806,200.44100831600832,202.43217255717258,null,9,64.233367983367984,65.192047817047822,65.855509355509355,66.813669438669436,67.477390852390855]
[10,20743,21058.083333333332,21276.083333333332,21591.083333333332,21809.25,null,23811110.083333332,16481148.083333334,23805351.083333332,null,10,20743,21058.083333333332,21276.083333333332,21591.083333333332,21809.25,null,23811110.083333332,16481148.083333334,23805351.083333332,16494265.25,null,10,170849,78067,248916,3221,5451,8672,10903,null,2595,4391,6985,8782,null,3781,6397,10177,12795,null,248916,{"$f":"$AA15+AL15","v":252697},255313,259093,261711,null,170849,78066.546117000005,248916,null,3781,6397,10177,12795,null,248916,252697,255313,259093,261711,null,10,129.37422037422039,131.3393970893971,132.69906444906445,134.66372141372142,136.02442827442829,null,10,194.06133056133058,197.00909563409564,199.04859667359668,201.99558212058213,204.03664241164245,null,10,64.687110187110193,65.669698544698548,66.349532224532226,67.331860706860709,68.012214137214144]
[11,21137.916666666668,21460.75,21684.416666666668,22007.25,22230.833333333332,null,24396668.75,16909412.416666668,24397215.25,null,11,21137.916666666668,21460.75,21684.416666666668,22007.25,22230.833333333332,null,24396668.75,16909412.416666668,24397215.25,16903666.833333332,null,11,173067,{"$f":"IF(beregningsdato>=$AA$5,ROUND((Y16+$Y$5)*regulering,0),ROUND(Y16*regulering,0))","v":79553},{"$f":"IF(beregningsdato>=$AA$5,SUM($Y$5,Y16:Z16),SUM(Y16:Z16))","v":253655},3301,5588,8889,11175,2659,2659,4501,7160,9002,null,3874,6558,10432,13115,null,253655,257529,260213,264087,266770,null,173067,{"$f":"IF(beregningsdato>=$AA$5,ROUND((AW16+$Y$5)*regulering,0),ROUND(AW16*regulering,0))","v":79553},{"$f":"IF(beregningsdato>=$AA$5,SUM($Y$5,AW16:AX16),SUM(AW16:AX16))","v":253655},null,3874,6558,10432,13115,null,253655,257529,260213,264087,266770,null,11,131.8373180873181,133.85083160083161,135.245841995842,137.25935550935552,138.65384615384616,null,11,197.75597713097716,200.77624740124742,202.868762993763,205.88903326403329,207.98076923076923,null,11,65.918659043659048,66.925415800415806,67.622920997921,68.629677754677758,69.32692307692308]
[12,21497.916666666668,21828.916666666668,22058,22389.083333333332,22618.166666666668,null,25013652.916666668,17318766,25020505.083333332,null,12,21497.916666666668,21828.916666666668,22058,22389.083333333332,22618.166666666668,null,25013652.916666668,17318766,25020505.083333332,17319326.166666668,null,12,176032,{"$f":"IF(beregningsdato>=$AA$5,ROUND((Y17+$Y$5)*regulering,0),ROUND(Y17*regulering,0))","v":80908},257975,3384,5727,9112,11455,2726,2726,4613,7340,9227,null,3972,6721,10694,13443,null,257975,261947,264696,268669,271418,null,176032,{"$f":"IF(beregningsdato>=$AA$5,ROUND((AW17+$Y$5)*regulering,0),ROUND(AW17*regulering,0))","v":80908},257975,null,3972,6721,10694,13443,null,257975,261947,264696,268669,271418,null,12,134.08264033264032,136.14708939708939,137.57588357588358,139.64085239085239,141.06964656964658,null,12,201.12396049896049,204.22063409563407,206.36382536382536,209.46127858627858,211.60446985446987,null,12,67.041320166320162,68.073544698544694,68.78794178794179,69.820426195426194,70.53482328482329]
[13,21868.083333333332,22207.416666666668,22442.333333333332,22781.666666666668,23016.666666666668,null,25643231.416666668,17759590.333333332,25643805.666666668,null,13,21868.083333333332,22207.416666666668,22442.333333333332,22781.666666666668,23016.666666666668,null,25643231.416666668,17759590.333333332,25643805.666666668,17766456.666666668,null,13,179081,{"$f":"IF(beregningsdato>=$AA$5,ROUND((Y18+$Y$5)*regulering,0),ROUND(Y18*regulering,0))","v":82301},262417,3470,5872,9342,11744,2795,2795,4730,7525,9460,null,4072,6891,10963,13783,null,262417,266489,269308,273380,276200,null,179081,{"$f":"IF(beregningsdato>=$AA$5,ROUND((AW18+$Y$5)*regulering,0),ROUND(AW18*regulering,0))","v":82301},262417,null,4072,6891,10963,13783,null,262417,266489,269308,273380,276200,null,13,136.39137214137213,138.50779625779626,139.97297297297297,142.0893970893971,143.55509355509355,null,13,204.5870582120582,207.76169438669439,209.95945945945945,213.13409563409564,215.33264033264032,null,13,68.195686070686065,69.253898128898129,69.986486486486484,71.044698544698548,71.777546777546775]
[14,22248.5,22596.333333333332,22837.083333333332,23185.083333333332,23425.916666666668,null,26285404.333333332,18200425.083333332,26298577.083333332,null,14,22248.5,22596.333333333332,22837.083333333332,23185.083333333332,23425.916666666668,null,26285404.333333332,18200425.083333332,26298577.083333332,18207305.916666668,null,14,182214,83733,266982,3557,6019,9577,12039,2865,2865,4848,7714,9698,null,4174,7063,11239,14129,null,266982,271156,274045,278221,281111,null,182214,83733,266982,null,4174,7063,11239,14129,null,266982,271156,274045,278221,281111,null,14,138.76403326403326,140.93347193347194,142.43503118503119,144.60550935550935,146.10758835758836,null,14,208.14604989604987,211.4002079002079,213.65254677754677,216.90826403326403,219.16138253638252,null,14,69.382016632016629,70.466735966735968,71.217515592515596,72.302754677754677,73.053794178794178]
[15,22624.083333333332,22980.666666666668,23227.75,23584.166666666668,23831.166666666668,null,26946448.666666668,18679007.75,26934468.166666668,null,15,22624.083333333332,22980.666666666668,23227.75,23584.166666666668,23831.166666666668,null,26946448.666666668,18679007.75,26934468.166666668,18673319.166666668,null,15,185308,85146,271489,3646,6172,9818,12343,2937,2937,4972,7908,9942,null,4279,7244,11521,14485,null,271489,275768,278733,283010,285974,null,185308,85146,271489,null,4279,7244,11521,14485,null,271489,275768,278733,283010,285974,null,15,141.10654885654887,143.33056133056132,144.87162162162161,147.09459459459458,148.63513513513513,null,15,211.65982328482329,214.995841995842,217.30743243243242,220.64189189189187,222.95270270270271,null,15,70.553274428274435,71.665280665280662,72.435810810810807,73.547297297297291,74.317567567567565]
[16,23008.583333333332,23374.166666666668,23627.333333333332,23992.833333333332,24246.25,null,27626378.166666668,19138723.333333332,27620704.833333332,null,16,23008.583333333332,23374.166666666668,23627.333333333332,23992.833333333332,24246.25,null,27626378.166666668,19138723.333333332,27620704.833333332,19158218.25,null,16,188475,86593,276103,3738,6327,10065,12655,3011,3011,5096,8107,10194,null,4387,7425,11811,14852,null,276103,280490,283528,287914,290955,null,188475,86593,276103,null,4387,7425,11811,14852,null,276103,280490,283528,287914,290955,null,16,143.50467775467774,145.78482328482329,147.36382536382536,149.64345114345113,151.22401247401248,null,16,215.25701663201662,218.67723492723493,221.04573804573803,224.46517671517671,226.83601871101871,null,16,71.752338877338872,72.892411642411645,73.681912681912678,74.821725571725565,75.612006237006241]
[17,{"$f":"AQ22/12","v":23328.083333333332},23704.666666666668,23965.5,24342.25,24602.916666666668,null,28457252.666666668,19717925.5,28470474.25,null,17,{"$f":"BF22/12","v":23328.083333333332},23704.666666666668,23965.5,24342.25,24602.916666666668,null,28457252.666666668,19717925.5,28470474.25,19705978.916666668,null,17,191106,87796,279937,3851,6518,10370,13035,3102,3102,5250,8353,10500,null,4519,7649,12170,15298,null,279937,284456,287586,292107,295235,null,191106,87796,279937,null,4519,7649,12170,15298,null,279937,{"$f":"$BF22+BA22","v":284456},287586,292107,295235,null,17,{"$f":"AQ22/1924","v":145.49740124740126},147.84615384615384,149.47297297297297,151.82276507276507,153.44854469854471,null,17,218.24610187110187,221.76923076923077,224.20945945945945,227.73414760914761,230.17281704781706,null,17,{"$f":"AQ22/1924/2","v":72.748700623700628},73.92307692307692,74.736486486486484,75.911382536382533,76.724272349272354]
[18,23754.083333333332,24140.333333333332,24407.666666666668,24794,25061.333333333332,null,29187560.333333332,20209143.666666668,29194506,null,18,23754.083333333332,24140.333333333332,24407.666666666668,24794,25061.333333333332,null,29187560.333333332,20209143.666666668,29194506,20209797.333333332,null,18,194615,89399,285049,3949,6683,10633,13367,3181,3181,5383,8565,10767,null,4635,7843,12479,15687,null,285049,289684,292892,297528,300736,null,194615,89399,285049,null,4635,7843,12479,15687,null,285049,289684,292892,297528,300736,null,18,148.1543659043659,150.56340956340955,152.23076923076923,154.64033264033264,156.30769230769232,null,18,{"$f":"AQ23/1924*1.5","v":222.23154885654884},225.84511434511433,228.34615384615384,231.96049896049897,234.46153846153848,null,18,74.077182952182952,75.281704781704775,76.115384615384613,77.320166320166322,78.15384615384616]
[19,24073,24469.083333333332,24743.333333333332,25139.333333333332,25413.583333333332,null,29930345.083333332,20731715.333333332,29924723.333333332,null,19,24073,24469.083333333332,24743.333333333332,25139.333333333332,25413.583333333332,null,29930345.083333332,20731715.333333332,29924723.333333332,20732385.583333332,null,19,197242,90599,288876,4050,6854,10904,13708,3262,3262,5521,8783,11042,null,4753,8044,12796,16087,null,288876,293629,296920,301672,304963,null,197242,90599,288876,null,4753,8044,12796,16087,null,288876,293629,296920,301672,304963,null,19,150.14345114345113,152.61382536382536,154.32432432432432,156.7941787941788,158.50467775467774,null,19,225.21517671517671,228.92073804573803,231.48648648648648,235.19126819126819,237.75701663201662,null,19,75.071725571725565,76.306912681912678,77.162162162162161,78.397089397089402,79.252338877338872]
[20,24357.75,24763.833333333332,25045.083333333332,25451.333333333332,25732.333333333332,null,30685679.833333332,21260545.083333332,30698951.333333332,null,20,24357.75,24763.833333333332,25045.083333333332,25451.333333333332,25732.333333333332,null,30685679.833333332,21260545.083333332,30698951.333333332,21242356.333333332,null,20,199969,{"$f":"IF(beregningsdato>=$AB$5,ROUND((Y25+$AC$5)*regulering,0),ROUND(Y25*regulering,0))","v":91671},{"$f":"IF(beregningsdato>=$AB$5,SUM($AC$5,Y25:Z25),SUM(Y25:Z25))","v":292293},4153,7028,11182,14056,3345,3345,5661,9007,11322,null,4873,8248,13123,16495,null,292293,297166,300541,305416,308788,null,199969,{"$f":"IF(beregningsdato>=$AB$5,ROUND((AW25+$AC$5)*regulering,0),ROUND(AW25*regulering,0))","v":91671},{"$f":"IF(beregningsdato>=$AB$5,SUM($AC$5,AW25:AX25),SUM(AW25:AX25))","v":292293},null,4873,8248,13123,16495,null,292293,297166,300541,305416,308788,null,20,151.91943866943868,154.45218295218297,156.20634095634097,158.74012474012474,160.49272349272348,null,20,227.879158004158,231.67827442827445,234.30951143451145,238.1101871101871,240.73908523908523,null,20,75.959719334719338,77.226091476091483,78.103170478170483,79.370062370062371,80.246361746361742]
[21,24760.416666666668,25177,25465.333333333332,25881.916666666668,26170.25,null,31478885,21795785.333333332,31479589.916666668,null,21,24760.416666666668,25177,25465.333333333332,25881.916666666668,26170.25,null,31478885,21795785.333333332,31479589.916666668,21796490.25,null,21,203286,{"$f":"IF(beregningsdato>=$AB$5,ROUND((Y26+$AC$5)*regulering,0),ROUND(Y26*regulering,0))","v":93186},{"$f":"IF(beregningsdato>=$AB$5,SUM($AC$5,Y26:Z26),SUM(Y26:Z26))","v":297125},4259,7208,11467,14416,3431,3431,5806,9237,11612,null,{"$f":"ROUND(VLOOKUP($X26,$X:$AJ,(4+AL$4)+$AM$5)*(1+$AL$5),0)","v":4999},8459,13458,16918,null,297125,302124,305584,310583,314043,null,203286,{"$f":"IF(beregningsdato>=$AB$5,ROUND((AW26+$AC$5)*regulering,0),ROUND(AW26*regulering,0))","v":93186},{"$f":"IF(beregningsdato>=$AB$5,SUM($AC$5,AW26:AX26),SUM(AW26:AX26))","v":297125},null,4999,8459,13458,16918,null,297125,302124,305584,310583,314043,null,21,154.43087318087319,157.02910602910603,158.82744282744284,161.42567567567568,163.22401247401248,null,21,231.6463097713098,235.54365904365903,238.24116424116426,242.13851351351352,244.83601871101871,null,21,77.215436590436596,78.514553014553016,79.413721413721419,80.712837837837839,81.612006237006241]
[22,25054.666666666668,25471.25,25759.583333333332,26176.166666666668,26464.5,null,31479179.25,21796079.583333332,31479884.166666668,null,22,25054.666666666668,25471.25,25759.583333333332,26176.166666666668,26464.5,null,31479179.25,21796079.583333332,31479884.166666668,21796784.5,null,22,206362,94294,300656,4259,7208,11467,14416,null,3431,5806,9237,11612,null,4999,8459,13458,16918,null,300656,305655,309115,314114,317574,null,206362,94293.607746000009,300656,null,4999,8459,13458,16918,null,300656,305655,309115,314114,317574,null,22,156.26611226611226,158.86434511434513,160.6626819126819,163.26091476091477,165.05925155925155,null,22,234.39916839916839,238.29651767151768,240.99402286902284,244.89137214137216,247.58887733887732,null,22,78.13305613305613,79.432172557172564,80.331340956340952,81.630457380457386,82.529625779625775]
[23,25454.166666666668,25859.416666666668,26139.75,26544.916666666668,26825.416666666668,null,30623855.416666668,21192427.75,30618248.916666668,null,23,25454.166666666668,25859.416666666668,26139.75,26544.916666666668,26825.416666666668,null,30623855.416666668,21192427.75,30618248.916666668,21205697.416666668,null,23,209653,95797,305450,4144,7010,11153,14021,null,3338,5647,8984,11294,null,4863,8227,13089,16455,null,305450,310313,313677,318539,321905,null,209653,95797.374249,305450,null,4863,8227,13089,16455,null,305450,310313,313677,318539,321905,null,23,158.75779625779626,161.28534303534303,163.03378378378378,165.56081081081081,167.31029106029106,null,23,238.13669438669439,241.92801455301455,244.55067567567568,248.3412162162162,250.96543659043658,null,23,79.378898128898129,80.642671517671516,81.516891891891888,82.780405405405403,83.655145530145532]
[24,25866.5,26260.083333333332,26532.666666666668,26926.333333333332,27198.75,null,29743376.083333332,20607664.666666668,29750334.333333332,null,24,25866.5,26260.083333333332,26532.666666666668,26926.333333333332,27198.75,null,29743376.083333332,20607664.666666668,29750334.333333332,20595746.75,null,24,213049,97349,310398,4025,6812,10837,13623,null,3242,5487,8729,10973,null,4723,7994,12718,15987,null,310398,315121,318392,323116,326385,null,213049,97349.118717000005,310398,null,4723,7994,12718,15987,null,310398,315121,318392,323116,326385,null,24,161.32952182952184,163.78430353430355,165.48440748440748,167.93970893970894,169.63877338877339,null,24,241.99428274428277,245.67645530145532,248.22661122661123,251.90956340956342,254.45816008316007,null,24,80.664760914760919,81.892151767151773,82.742203742203742,83.969854469854468,84.819386694386694]
[25,26287.416666666668,26668.75,26932.75,27314.166666666668,{"$f":"AU30/12","v":27578.166666666668},null,28818860.75,19959988.75,28825798.166666668,null,25,26287.416666666668,26668.75,26932.75,27314.166666666668,27578.166666666668,null,28818860.75,19959988.75,28825798.166666668,19960634.166666668,null,25,216516,98933,315449,3899,6598,10499,13198,null,3141,5315,8457,10631,null,4576,7744,12321,15489,null,315449,320025,323193,327770,330938,null,216516,98933.305428000007,315449,null,4576,7744,12321,15489,null,315449,320025,323193,327770,330938,null,25,163.95478170478171,166.3331600831601,167.97972972972974,170.35862785862787,172.00519750519751,null,25,245.93217255717258,249.49974012474013,251.96959459459461,255.5379417879418,258.00779625779626,null,25,81.977390852390855,83.166580041580048,83.98986486486487,85.179313929313935,86.002598752598757]
[26,26718.083333333332,27086.416666666668,27341.25,27709.416666666668,27964.333333333332,null,27837726.416666668,19268277.25,27825765.416666668,null,26,26718.083333333332,27086.416666666668,27341.25,27709.416666666668,27964.333333333332,null,27837726.416666668,19268277.25,27825765.416666668,19275192.333333332,null,26,220063,100554,320617,3766,6372,10137,12743,null,3034,5133,8165,10265,null,4420,7478,11896,14955,null,320617,325037,328095,332513,335572,null,220063,100554.04677900001,320617,null,4420,7478,11896,14955,null,320617,325037,328095,332513,335572,null,26,166.64085239085239,168.93814968814968,170.52754677754677,172.82380457380458,174.41372141372142,null,26,249.96127858627858,253.40722453222452,255.79132016632016,259.23570686070684,261.62058212058213,null,26,83.320426195426194,84.469074844074839,85.263773388773387,86.41190228690229,87.206860706860709]
[27,27158.583333333332,27512.75,27757.75,28111.916666666668,28357,null,26768512.75,18526237.75,26769111.916666668,null,27,27158.583333333332,27512.75,27757.75,28111.916666666668,28357,null,26768512.75,18526237.75,26769111.916666668,18533129,null,27,223691,102212,325903,3621,6127,9748,12254,null,2917,4935,7852,9871,null,4250,7190,11440,14381,null,325903,330153,333093,337343,340284,null,223691,102211.79970300001,325903,null,4250,7190,11440,14381,null,325903,330153,333093,337343,340284,null,27,169.38825363825364,171.59719334719335,173.12525987525987,175.33419958419958,176.86278586278587,null,27,254.08238045738045,257.39579002079006,259.68788981288981,263.00129937629936,265.29417879417883,null,27,84.694126819126822,85.798596673596677,86.562629937629936,87.667099792099791,88.431392931392935]
[28,27608.75,27947.833333333332,28182.5,28521.666666666668,28756.166666666668,null,25630095.833333332,17746454.5,25636961.666666668,null,28,27608.75,27947.833333333332,28182.5,28521.666666666668,28756.166666666668,null,25630095.833333332,17746454.5,25636961.666666668,17734444.166666668,null,28,227399,103906,331305,3467,5867,9334,11733,null,2793,4726,7519,9451,null,4069,6885,10955,13769,null,331305,335374,338190,342260,345074,null,227399,103906.10726700001,331305,null,4069,6885,10955,13769,null,331305,335374,338190,342260,345074,null,28,172.19594594594594,174.31081081081081,175.77442827442829,177.8898128898129,179.35239085239084,null,28,258.29391891891891,261.4662162162162,263.66164241164245,266.83471933471935,269.02858627858626,null,28,86.097972972972968,87.155405405405403,87.887214137214144,88.944906444906451,89.67619542619542]
[29,28069.166666666668,28392.25,28615.75,28938.75,29162.333333333332,null,24422476.25,16903759.75,24416730.75,null,29,28069.166666666668,28392.25,28615.75,28938.75,29162.333333333332,null,24422476.25,16903759.75,24416730.75,16910598.333333332,null,29,231191,105639,336830,3303,5589,8891,11178,null,2661,4502,7162,9004,null,3877,6559,10435,13118,null,336830,340707,343389,347265,349948,null,231191,105638.79720300001,336830,null,3877,6559,10435,13118,null,336830,340707,343389,347265,349948,null,29,175.06756756756758,177.08264033264032,178.47661122661123,180.49116424116423,181.88565488565487,null,29,262.60135135135135,265.62396049896051,267.71491683991684,270.73674636174633,272.82848232848232,null,29,87.53378378378379,88.541320166320162,89.238305613305613,90.245582120582114,90.942827442827436]
[30,28539.5,28845.333333333332,29057.166666666668,29362.916666666668,29574.666666666668,null,23120485.333333332,16023321.166666666,23114710.916666668,null,30,28539.5,28845.333333333332,29057.166666666668,29362.916666666668,29574.666666666668,null,23120485.333333332,16023321.166666666,23114710.916666668,16017546.666666666,null,30,235065,107409,342474,3127,5293,8420,10585,null,2519,4264,6782,8526,null,3670,6212,9881,12422,null,342474,346144,348686,352355,354896,null,235065,107408.95564500001,342474,null,3670,6212,9881,12422,null,342474,346144,348686,352355,354896,null,30,178.00103950103951,179.9085239085239,181.22972972972974,183.13669438669439,184.45738045738045,null,30,267.00155925155929,269.86278586278587,271.84459459459458,274.70504158004155,276.68607068607071,null,30,89.000519750519757,89.954261954261952,90.61486486486487,91.568347193347194,92.228690228690226]
[31,29020.5,29308.25,29507.333333333332,29795.083333333332,29994.25,null,21755584.25,15061095.333333334,21756071.083333332,null,31,29020.5,29308.25,29507.333333333332,29795.083333333332,29994.25,null,21755584.25,15061095.333333334,21756071.083333332,15067874.25,null,31,239027,109219,348246,2942,4978,7920,9956,null,2370,4010,6380,8020,null,3453,5842,9295,11685,null,348246,351699,354088,357541,359931,null,239027,109219.32419100001,348246,null,3453,5842,9295,11685,null,348246,351699,354088,357541,359931,null,31,181.00103950103951,182.79573804573803,184.03742203742203,185.83212058212058,187.07432432432432,null,31,271.50155925155929,274.19360706860704,276.05613305613304,278.7481808731809,280.61148648648646,null,31,90.500519750519757,91.397869022869017,92.018711018711016,92.91606029106029,93.537162162162161]
[32,29512.25,29780.583333333332,29966.166666666668,30234.666666666668,30420.416666666668,null,20290020.583333332,14042250.166666666,20303058.666666668,null,32,29512.25,29780.583333333332,29966.166666666668,30234.666666666668,30420.416666666668,null,20290020.583333332,14042250.166666666,20303058.666666668,14055288.416666666,null,32,243077,111070,354147,2743,4642,7387,9286,null,2210,3739,5950,7480,null,3220,5447,8669,10898,null,354147,357367,359594,362816,365045,null,243077,111069.902841,354147,null,3220,5447,8669,10898,null,354147,357367,359594,362816,365045,null,32,184.06808731808732,185.741683991684,186.89916839916839,188.57380457380458,189.73232848232848,null,32,276.10213097713097,278.612525987526,280.34875259875258,282.86070686070684,284.59849272349271,null,32,92.034043659043661,92.870841995842,93.449584199584194,94.28690228690229,94.866164241164242]
[33,30014.666666666668,30262.5,30434,30681.833333333332,30853.25,null,18742670.5,12979370,18743089.833333332,null,33,30014.666666666668,30262.5,30434,30681.833333333332,30853.25,null,18742670.5,12979370,18743089.833333332,12973497.25,null,33,247215,{"$f":"ROUND(Y38*regulering,0)","v":112961},360176,2534,4288,6822,8575,null,2041,3454,5495,6907,null,2974,5032,8006,10063,null,360176,363150,365208,368182,370239,null,247215,{"$f":"AW38*regulering","v":112960.69159500001},360176,null,{"$f":"ROUND(AL38*udbygningspct,0)","v":2974},{"$f":"ROUND(AM38*udbygningspct,0)","v":5032},{"$f":"ROUND(AN38*udbygningspct,0)","v":8006},{"$f":"ROUND(AO38*udbygningspct,0)","v":10063},null,360176,363150,365208,368182,370239,null,33,187.20166320166319,188.74740124740126,189.81704781704781,191.36278586278587,192.43191268191268,null,33,280.80249480249478,283.12110187110187,284.72557172557174,287.04417879417883,288.64786902286903,null,33,93.600831600831597,94.373700623700628,94.908523908523904,95.681392931392935,96.215956340956339]
[34,30528.666666666668,30754.75,30911.083333333332,31137.166666666668,31293.666666666668,null,17100950.75,11834703.083333334,17101333.166666668,null,34,30528.666666666668,30754.75,30911.083333333332,31137.166666666668,31293.666666666668,null,17100950.75,11834703.083333334,17101333.166666668,11847669.666666666,null,34,251449,114895,366344,2311,3911,6222,7823,null,1862,3150,5012,6301,null,2713,4589,7302,9180,null,366344,369057,370933,373646,375524,null,251449,114895.34591700001,366344,null,2713,4589,7302,9180,null,366344,369057,370933,373646,375524,null,34,190.40748440748442,191.81756756756758,192.79261954261955,194.20270270270271,195.17879417879419,null,34,285.61122661122664,287.72635135135135,289.18892931392929,291.30405405405406,292.76819126819129,null,34,95.203742203742209,95.90878378378379,96.396309771309774,97.101351351351354,97.589397089397096]
[35,31053.583333333332,31256.583333333332,31397.083333333332,31599.916666666668,31740.5,null,15358568.583333334,10639709.083333334,15346327.916666666,null,35,31053.583333333332,31256.583333333332,31397.083333333332,31599.916666666668,31740.5,null,15358568.583333334,10639709.083333334,15346327.916666666,10646344.5,null,35,255772,116871,372643,2076,3512,5586,7024,null,1672,2829,4500,5658,null,2436,4122,6556,8243,null,372643,375079,376765,379199,380886,null,255772,116870.66727600001,372643,null,2436,4122,6556,8243,null,372643,375079,376765,379199,380886,null,35,193.68139293139293,194.94750519750519,195.82380457380458,197.08887733887735,197.96569646569645,null,35,290.52208939708942,292.42125779625781,293.73570686070684,295.633316008316,296.94854469854465,null,35,96.840696465696467,97.473752598752597,97.91190228690229,98.544438669438676,98.982848232848227]
[36,31590.416666666668,31769,31892.5,32071,32194.583333333332,null,13515525,9356636.5,13509535,null,36,31590.416666666668,31769,31892.5,32071,32194.583333333332,null,13515525,9356636.5,13509535,9363230.583333334,null,36,260194,118891,379085,1826,3089,4914,6177,null,1471,2488,3958,4976,null,2143,3625,5767,7250,null,379085,381228,382710,384852,386335,null,260194,118891.22500200001,379085,null,2143,3625,5767,7250,null,379085,381228,382710,384852,386335,null,36,197.02962577962577,198.14345114345113,198.91372141372142,200.02702702702703,200.79781704781703,null,36,295.54443866943865,297.21517671517671,298.37058212058213,300.04054054054052,301.19672557172555,null,36,98.514812889812887,99.071725571725565,99.456860706860709,100.01351351351352,100.39890852390852]
[37,32139,32291.583333333332,32397.333333333332,32550,32655.583333333332,null,11552943.583333334,8016945.333333333,11559494,null,37,32139,32291.583333333332,32397.333333333332,32550,32655.583333333332,null,11552943.583333334,8016945.333333333,11559494,8004619.583333333,null,37,264712,120956,385668,1560,2642,4202,5282,null,1257,2128,3385,4255,null,1831,3100,4932,6199,null,385668,387499,388768,390600,391867,null,264712,120955.64829600001,385668,null,1831,3100,4932,6199,null,385668,387499,388768,390600,391867,null,37,200.45114345114345,201.40280665280665,202.06237006237006,203.014553014553,203.67307692307693,null,37,300.67671517671516,302.10420997920994,303.0935550935551,304.52182952182949,305.50961538461542,null,37,100.22557172557173,100.70140332640332,101.03118503118503,101.5072765072765,101.83653846153847]
[38,32721.25,32849,32937.5,33065.166666666664,33153.833333333336,null,9678485,6715041.5,9672409.166666666,null,38,32721.25,32849,32937.5,33065.166666666664,33153.833333333336,null,9678485,6715041.5,9672409.166666666,6727841.833333333,null,38,269508,123147,392655,1306,2211,3517,4423,null,1052,1781,2833,3563,null,1533,2595,4127,5191,null,392655,394188,395250,396782,397846,null,269508,123147.098964,392655,null,1533,2595,4127,5191,null,392655,394188,395250,396782,397846,null,38,204.08264033264032,204.87941787941787,205.43139293139293,206.22765072765074,206.78066528066529,null,38,306.12396049896051,307.31912681912684,308.14708939708942,309.34147609147612,310.17099792099793,null,38,102.04132016632016,102.43970893970894,102.71569646569647,103.11382536382537,103.39033264033264]
[39,33305.833333333336,33404.166666666664,33472.25,33570.666666666664,33638.833333333336,null,7457964.166666667,5174036.25,7464422.666666667,null,39,33305.833333333336,33404.166666666664,33472.25,33570.666666666664,33638.833333333336,null,7457964.166666667,5174036.25,7464422.666666667,5180494.833333333,null,39,274323,125347,399670,1006,1702,2708,3405,null,810,1371,2181,2743,null,1180,1997,3178,3996,null,399670,400850,401667,402848,403666,null,274323,125347.23135900001,399670,null,1180,1997,3178,3996,null,399670,400850,401667,402848,403666,null,39,207.72869022869023,208.34199584199584,208.76663201663203,209.38045738045739,209.80561330561329,null,39,311.59303534303535,312.51299376299374,313.14994802494806,314.07068607068607,314.70841995841994,null,39,103.86434511434511,104.17099792099792,104.38331600831602,104.69022869022869,104.90280665280665]
[40,33903.666666666664,33970.916666666664,34017.583333333336,34084.916666666664,34131.583333333336,null,5111614.916666667,3557537.5833333335,5118020.916666667,null,40,33903.666666666664,33970.916666666664,34017.583333333336,34084.916666666664,34131.583333333336,null,5111614.916666667,3557537.5833333335,5118020.916666667,3557651.5833333335,null,40,279247,127597,406844,688,1165,1853,2330,null,554,938,1493,1877,null,807,1367,2175,2735,null,406844,407651,408211,409019,409579,null,279247,127597.16945100001,406844,null,807,1367,2175,2735,null,{"$f":"AY45","v":406844},407651,408211,409019,409579,null,40,211.45738045738045,211.87681912681913,212.16787941787942,212.58783783783784,212.87889812889813,null,40,317.18607068607071,317.81522869022871,318.2518191268191,318.88175675675677,319.31834719334722,null,40,105.72869022869023,105.93840956340956,106.08393970893971,106.29391891891892,106.43944906444906]
[41,34514.5,34549,34573,34607.416666666664,34631.416666666664,null,2639437,1846669,2633203.4166666665,null,41,34514.5,34549,34573,34607.416666666664,34631.416666666664,null,2639437,1846669,2633203.4166666665,1846727.4166666667,null,41,284278,129896,414174,353,598,950,1195,null,284,482,765,963,null,{"$f":"ROUND(VLOOKUP($X46,$X:$AJ,(4+AL$4)+$AM$5)*(1+$AL$5),0)","v":414},702,1115,1403,null,414174,414588,414876,415289,415577,null,284278,129895.99937400001,414174,null,414,702,1115,1403,null,{"$f":"AY46","v":414174},414588,414876,415289,415577,null,41,215.26715176715177,215.48232848232848,215.63201663201664,215.84667359667358,215.99636174636174,null,41,322.90072765072767,323.22349272349271,323.44802494802497,323.77001039501039,323.99454261954259,null,41,107.63357588357589,107.74116424116424,107.81600831600832,107.92333679833679,107.99818087318087]
[42,35138.583333333336,35138.583333333336,35138.583333333336,35138.583333333336,35138.583333333336,null,35138.583333333336,35138.583333333336,35138.583333333336,null,42,35138.583333333336,35138.583333333336,35138.583333333336,35138.583333333336,35138.583333333336,null,35138.583333333336,35138.583333333336,35138.583333333336,35138.583333333336,null,42,289418,132245,421663,0,0,0,0,null,null,null,null,null,null,0,0,0,0,null,421663,421663,421663,421663,421663,null,289418,132244.63499400002,421663,null,0,0,0,0,null,421663,421663,421663,421663,421663,null,42,219.15956340956342,219.15956340956342,219.15956340956342,219.15956340956342,219.15956340956342,null,42,328.73934511434516,328.73934511434516,328.73934511434516,328.73934511434516,328.73934511434516,null,42,109.57978170478171,109.57978170478171,109.57978170478171,109.57978170478171,109.57978170478171]
[43,35919.5,35919.5,35919.5,35919.5,35919.5,null,35919.5,35919.5,35919.5,null,43,35919.5,35919.5,35919.5,35919.5,35919.5,null,35919.5,35919.5,35919.5,35919.5,null,43,295850,135184,431034,0,0,0,0,null,null,null,null,null,null,0,0,0,0,null,431034,431034,431034,431034,431034,null,295850,135183.62805,431034,null,0,0,0,0,null,431034,431034,431034,431034,431034,null,43,224.03014553014552,224.03014553014552,224.03014553014552,224.03014553014552,224.03014553014552,null,43,336.04521829521826,336.04521829521826,336.04521829521826,336.04521829521826,336.04521829521826,null,43,112.01507276507276,112.01507276507276,112.01507276507276,112.01507276507276,112.01507276507276]
[44,36722,36722,36722,36722,36722,null,36722,36722,36722,null,44,36722,36722,36722,36722,36722,null,36722,36722,36722,36722,null,44,302460,138204,440664,0,0,0,0,null,null,null,null,null,null,0,0,0,0,null,440664,440664,440664,440664,440664,null,302460,138203.95518000002,440664,null,0,0,0,0,null,440664,440664,440664,440664,440664,null,44,229.03534303534303,229.03534303534303,229.03534303534303,229.03534303534303,229.03534303534303,null,44,343.55301455301458,343.55301455301458,343.55301455301458,343.55301455301458,343.55301455301458,null,44,114.51767151767152,114.51767151767152,114.51767151767152,114.51767151767152,114.51767151767152]
[45,37546.5,37546.5,37546.5,37546.5,37546.5,null,37546.5,37546.5,37546.5,null,45,37546.5,37546.5,37546.5,37546.5,37546.5,null,37546.5,37546.5,37546.5,37546.5,null,45,309251,141307,450558,0,0,0,0,null,null,null,null,null,null,0,0,0,0,null,450558,450558,450558,450558,450558,null,309251,141306.98718300002,450558,null,0,0,0,0,null,450558,450558,450558,450558,450558,null,45,234.17775467775468,234.17775467775468,234.17775467775468,234.17775467775468,234.17775467775468,null,45,351.266632016632,351.266632016632,351.266632016632,351.266632016632,351.266632016632,null,45,117.08887733887734,117.08887733887734,117.08887733887734,117.08887733887734,117.08887733887734]
[46,38393.666666666664,38393.666666666664,38393.666666666664,38393.666666666664,38393.666666666664,null,38393.666666666664,38393.666666666664,38393.666666666664,null,46,38393.666666666664,38393.666666666664,38393.666666666664,38393.666666666664,38393.666666666664,null,38393.666666666664,38393.666666666664,38393.666666666664,38393.666666666664,null,46,316229,144495,460724,0,0,0,0,null,null,null,null,null,null,0,0,0,0,null,460724,460724,460724,460724,460724,null,316229,144495.46565700002,460724,null,0,0,0,0,null,460724,460724,460724,460724,460724,null,46,239.46153846153845,239.46153846153845,239.46153846153845,239.46153846153845,239.46153846153845,null,46,359.19230769230768,359.19230769230768,359.19230769230768,359.19230769230768,359.19230769230768,null,46,119.73076923076923,119.73076923076923,119.73076923076923,119.73076923076923,119.73076923076923]
[47,39077.166666666664,39077.166666666664,39077.166666666664,39077.166666666664,39077.166666666664,null,39077.166666666664,39077.166666666664,39077.166666666664,null,47,39077.166666666664,39077.166666666664,39077.166666666664,39077.166666666664,39077.166666666664,null,39077.166666666664,39077.166666666664,39077.166666666664,39077.166666666664,null,47,321858,147068,468926,0,0,0,0,null,null,null,null,null,null,0,0,0,0,null,468926,468926,468926,468926,468926,null,321858,147067.54151400001,468926,null,0,0,0,0,null,468926,468926,468926,468926,468926,null,47,243.72453222453223,243.72453222453223,243.72453222453223,243.72453222453223,243.72453222453223,null,47,365.58679833679832,365.58679833679832,365.58679833679832,365.58679833679832,365.58679833679832,null,47,121.86226611226611,121.86226611226611,121.86226611226611,121.86226611226611,121.86226611226611]
[48,40873.416666666664,40873.416666666664,40873.416666666664,40873.416666666664,40873.416666666664,null,40873.416666666664,40873.416666666664,40873.416666666664,null,48,40873.416666666664,40873.416666666664,40873.416666666664,40873.416666666664,40873.416666666664,null,40873.416666666664,40873.416666666664,40873.416666666664,40873.416666666664,null,48,336653,153828,490481,0,0,0,0,null,null,null,null,null,null,0,0,0,0,null,490481,490481,490481,490481,490481,null,336653,153827.86524900002,490481,null,0,0,0,0,null,490481,490481,490481,490481,490481,null,48,254.92775467775468,254.92775467775468,254.92775467775468,254.92775467775468,254.92775467775468,null,48,382.391632016632,382.391632016632,382.391632016632,382.391632016632,382.391632016632,null,48,127.46387733887734,127.46387733887734,127.46387733887734,127.46387733887734,127.46387733887734]
[49,43616.416666666664,43616.416666666664,43616.416666666664,43616.416666666664,43616.416666666664,null,43616.416666666664,43616.416666666664,43616.416666666664,null,49,{"$f":"BF54/12","v":43616.416666666664},43616.416666666664,43616.416666666664,43616.416666666664,43616.416666666664,null,43616.416666666664,43616.416666666664,43616.416666666664,43616.416666666664,null,49,359246,164151,523397,0,0,0,0,null,null,null,null,null,null,0,0,0,0,null,523397,523397,523397,523397,523397,null,359246,164151.352518,523397,null,0,0,0,0,null,523397,523397,523397,523397,523397,null,49,272.03586278586278,272.03586278586278,272.03586278586278,272.03586278586278,272.03586278586278,null,49,408.05379417879419,408.05379417879419,408.05379417879419,408.05379417879419,408.05379417879419,null,49,136.01793139293139,136.01793139293139,136.01793139293139,136.01793139293139,136.01793139293139]
[50,46661.166666666664,46661.166666666664,46661.166666666664,46661.166666666664,46661.166666666664,null,46661.166666666664,46661.166666666664,46661.166666666664,null,50,{"$f":"BF55/12","v":47761.75},47761.75,47761.75,47761.75,47761.75,null,47761.75,47761.75,47761.75,47761.75,null,50,384324,175610,559934,0,0,0,0,null,null,null,null,null,null,0,0,0,0,null,559934,559934,559934,559934,559934,null,393389,179752.41593700001,573141,null,0,0,0,0,null,573141,573141,573141,573141,573141,null,50,291.02598752598755,291.02598752598755,291.02598752598755,291.02598752598755,291.02598752598755,null,50,436.53898128898129,436.53898128898129,436.53898128898129,436.53898128898129,436.53898128898129,null,50,145.51299376299377,145.51299376299377,145.51299376299377,145.51299376299377,145.51299376299377]
[51,51540.666666666664,51540.666666666664,51540.666666666664,51540.666666666664,51540.666666666664,null,51540.666666666664,51540.666666666664,51540.666666666664,null,51,52928.083333333336,52928.083333333336,52928.083333333336,52928.083333333336,52928.083333333336,null,52928.083333333336,52928.083333333336,52928.083333333336,52928.083333333336,null,51,424514,193974,618488,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,618488,618488,618488,618488,618488,null,435941,199195.82895300002,635137,null,0,0,0,0,null,635137,635137,635137,635137,635137,null,51,321.45945945945948,321.45945945945948,321.45945945945948,321.45945945945948,321.45945945945948,null,51,482.18918918918922,482.18918918918922,482.18918918918922,482.18918918918922,482.18918918918922,null,51,160.72972972972974,160.72972972972974,160.72972972972974,160.72972972972974,160.72972972972974]
[52,58646.916666666664,58646.916666666664,58646.916666666664,58646.916666666664,58646.916666666664,null,58646.916666666664,58646.916666666664,58646.916666666664,null,52,60279.5,60279.5,60279.5,60279.5,60279.5,null,60279.5,60279.5,60279.5,60279.5,null,52,483044,220719,703763,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,703763,703763,703763,703763,703763,null,496491,226863.12210300003,723354,null,0,0,0,0,null,723354,723354,723354,723354,723354,null,52,365.78118503118503,365.78118503118503,365.78118503118503,365.78118503118503,365.78118503118503,null,52,548.67177754677755,548.67177754677755,548.67177754677755,548.67177754677755,548.67177754677755,null,52,182.89059251559252,182.89059251559252,182.89059251559252,182.89059251559252,182.89059251559252]
[53,64392.083333333336,64392.083333333336,64392.083333333336,64392.083333333336,64392.083333333336,null,64392.083333333336,64392.083333333336,64392.083333333336,null,53,67101.083333333328,67101.083333333328,67101.083333333328,67101.083333333328,67101.083333333328,null,67101.083333333328,67101.083333333328,67101.083333333328,67101.083333333328,null,53,530364,242341,772705,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,772705,772705,772705,772705,772705,null,552677,252536.35964100002,805213,null,0,0,0,0,null,805213,805213,805213,805213,805213,null,53,401.61382536382536,401.61382536382536,401.61382536382536,401.61382536382536,401.61382536382536,null,53,602.42073804573806,602.42073804573806,602.42073804573806,602.42073804573806,602.42073804573806,null,53,200.80691268191268,200.80691268191268,200.80691268191268,200.80691268191268,200.80691268191268]
[54,72051.25,72051.25,72051.25,72051.25,72051.25,null,72051.25,72051.25,72051.25,null,54,75603.166666666672,75603.166666666672,75603.166666666672,75603.166666666672,75603.166666666672,null,75603.166666666672,75603.166666666672,75603.166666666672,75603.166666666672,null,54,593449,271166,864615,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,864615,864615,864615,864615,864615,null,622704,284534.00683200004,907238,null,0,0,0,0,null,907238,907238,907238,907238,907238,null,54,449.38409563409562,449.38409563409562,449.38409563409562,449.38409563409562,449.38409563409562,null,54,674.07614345114348,674.07614345114348,674.07614345114348,674.07614345114348,674.07614345114348,null,54,224.69204781704781,224.69204781704781,224.69204781704781,224.69204781704781,224.69204781704781]
[55,81257.75,81257.75,81257.75,81257.75,81257.75,null,81257.75,81257.75,81257.75,null,55,84809.666666666672,84809.666666666672,84809.666666666672,84809.666666666672,84809.666666666672,null,84809.666666666672,84809.666666666672,84809.666666666672,84809.666666666672,null,55,669278,305815,975093,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,975093,975093,975093,975093,975093,null,698533,319182.77928900003,1017716,null,0,0,0,0,null,1017716,1017716,1017716,1017716,1017716,null,55,506.80509355509355,506.80509355509355,506.80509355509355,506.80509355509355,506.80509355509355,null,55,760.20764033264027,760.20764033264027,760.20764033264027,760.20764033264027,760.20764033264027,null,55,253.40254677754677,253.40254677754677,253.40254677754677,253.40254677754677,253.40254677754677]
[56,91581.5,91581.5,91581.5,91581.5,91581.5,null,91581.5,91581.5,91581.5,null,56,95133.583333333328,95133.583333333328,95133.583333333328,95133.583333333328,95133.583333333328,null,95133.583333333328,95133.583333333328,95133.583333333328,95133.583333333328,null,56,754309,344669,1098978,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,1098978,1098978,1098978,1098978,1098978,null,783566,358037.16307800001,1141603,null,0,0,0,0,null,1141603,1141603,1141603,1141603,1141603,null,56,571.19438669438671,571.19438669438671,571.19438669438671,571.19438669438671,571.19438669438671,null,56,856.79158004158012,856.79158004158012,856.79158004158012,856.79158004158012,856.79158004158012,null,56,285.59719334719335,285.59719334719335,285.59719334719335,285.59719334719335,285.59719334719335]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(Y62*valgt_regulering,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["2006-10-01",4131.67,4204.9799999999996,4265.26,4358.1099999999997,4420,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["2007-04-01",4229.54,4303.8900000000003,4365.01,4459.17,4521.93,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]

{"sheet":"Forside","index":3,"n_rows":15,"n_cols":11,"rows_kept":15,"cut":false,"hidden":false,"merged":[[14,3,14,7]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Lønniveau:","2022-04-01"]
[]
[]
[]
[null,null,null,"Hvad betyder det for lønnen, hvis man ændrer på lønsammensætning eller timetal ?"]

{"sheet":"Omregner","index":4,"n_rows":24,"n_cols":9,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Valgt lønniveau:",null,{"$f":"Forside!K11","v":"2022-04-01"},null,"Timetal:",37]
[]
[null,"1) Grundbeløb pr. 31-3-2000 omregnet til nutidskr. "]
[null,null,"Årligt grundbeløb:",null,11300]
[]
[null,null,null,null,"år","måned"]
[null,null,"Aktuelt beløb",null,{"$f":"ROUND(((kr_omregnes*valgt_regulering)/37*I11),0)","v":16463},{"$f":"E17/12","v":1371.9166666666667}]
[]
[]
[null,"2) Beløb der skal omregnes til '31-3-2000-niveau'"]
[null,null,"Månedligt beløb",null,1296.9000000000001]
[]
[null,null,null,null,"år","måned"]
[null,null,"Grundbeløb pr. 31-3-2000",null,{"$f":"ROUND(E21*12/valgt_regulering,0)/I11*37","v":10682},{"$f":"E24/12","v":890.16666666666663}]

{"sheet":"Omregningstabel ","index":5,"n_rows":25,"n_cols":16,"rows_kept":25,"cut":false,"hidden":true,"merged":[]}
[null,null,null,1.362716,1.3824959999999999,1.3980790000000001,1.018559,1.040662,1.0511569999999999,1.061566,1.0834220000000001,1.0886800000000001,1.0926750000000001,1.109523,1.1200380000000001,1.1244540000000001]
[]
[]
[]
[]
[]
[null,"Indtast beløb:",1000]
[]
[]
[null,null,"1/10 '84"]
[null,null,{"$f":"Beløb","v":1000},"1/4 '98"]
[null,"1/4-98",{"$f":"Beløb*_1_4_1998","v":1362.7160000000001},{"$f":"Beløb","v":1000},"1/10 '98"]
[null,"1/10-98",{"$f":"Beløb*_1_10_1998","v":1382.4959999999999},{"$f":"Beløb/_1_4_1998*_1_10_1998","v":1014.515130078461},{"$f":"Beløb","v":1000},"1/4 '99"]
[null,"1/4-99",{"$f":"Beløb*_1_4_1999","v":1398.0790000000002},{"$f":"Beløb/_1_4_1998*_1_4_1999","v":1025.9503814441161},{"$f":"Beløb/_1_10_1998*_1_4_1999","v":1011.2716420156008},{"$f":"Beløb","v":1000}]
[null,"Grundbeløb pr. 31/3-00",{"$f":"ROUND(C14,-2)","v":1400},{"$f":"ROUND(D14,-2)","v":1000},{"$f":"ROUND(E14,-2)","v":1000},{"$f":"ROUND(F14,-2)","v":1000},"1/4 '00"]
[null,"1/4-00",{"$f":"Nyt_beløb_1*_1_4_2000","v":1425.9826},{"$f":"Nyt_beløb_2*_1_4_2000","v":1018.559},{"$f":"Nyt_beløb_3*_1_4_2000","v":1018.559},{"$f":"Nyt_beløb_4*_1_4_2000","v":1018.559},{"$f":"Beløb","v":1000},"1/4 '01"]
[null,"1/4-01",{"$f":"Nyt_beløb_1*_1_4_2001","v":1456.9268},{"$f":"Nyt_beløb_2*_1_4_2001","v":1040.662},{"$f":"Nyt_beløb_3*_1_4_2001","v":1040.662},{"$f":"Nyt_beløb_4*_1_4_2001","v":1040.662},{"$f":"beløb_4_00/_1_4_2000*_1_4_2001","v":1021.7002647858396},{"$f":"Beløb","v":1000},"1/10 '01"]
[null,"1/10-01",{"$f":"Nyt_beløb_1*_1_10_2001","v":1471.6197999999999},{"$f":"Nyt_beløb_2*_1_10_2001","v":1051.1569999999999},{"$f":"Nyt_beløb_3*_1_10_2001","v":1051.1569999999999},{"$f":"Nyt_beløb_4*_1_10_2001","v":1051.1569999999999},{"$f":"beløb_4_00/_1_4_2000*_1_10_2001","v":1032.0040370759082},{"$f":"beløb_4_01/_1_4_2001*_1_10_2001","v":1010.0849267101133},{"$f":"Beløb","v":1000},"1/4 '02"]
[null,"1/4-02",{"$f":"Nyt_beløb_1*_1_4_2002","v":1486.1923999999999},{"$f":"Nyt_beløb_2*_1_4_2002","v":1061.566},{"$f":"Nyt_beløb_3*_1_4_2002","v":1061.566},{"$f":"Nyt_beløb_4*_1_4_2002","v":1061.566},{"$f":"beløb_4_00/_1_4_2000*_1_4_2002","v":1042.2233763581687},{"$f":"beløb_4_01/_1_4_2001*_1_4_2002","v":1020.0872137158848},{"$f":"beløb_10_01/_1_10_2001*_1_4_2002","v":1009.9024218075892},{"$f":"Beløb","v":1000},"1/4 '03"]
[null,"1/4-03",{"$f":"Nyt_beløb_1*_1_4_2003","v":1516.7908000000002},{"$f":"Nyt_beløb_2*_1_4_2003","v":1083.422},{"$f":"Nyt_beløb_3*_1_4_2003","v":1083.422},{"$f":"Nyt_beløb_4*_1_4_2003","v":1083.422},{"$f":"beløb_4_00/_1_4_2000*_1_4_2003","v":1063.6811416913504},{"$f":"beløb_4_01/_1_4_2001*_1_4_2003","v":1041.0892297403002},{"$f":"beløb_10_01/_1_10_2001*_1_4_2003","v":1030.6947487387708},{"$f":"beløb_4_02/_1_4_2002*_1_4_2003","v":1020.5884514010435},{"$f":"Beløb","v":1000},"1/8 '03"]
[null,"1/8-03",{"$f":"Nyt_beløb_1*_1_8_2003","v":1524.152},{"$f":"Nyt_beløb_2*_1_8_2003","v":1088.68},{"$f":"Nyt_beløb_3*_1_8_2003","v":1088.68},{"$f":"Nyt_beløb_4*_1_8_2003","v":1088.68},{"$f":"beløb_4_00/_1_4_2000*_1_8_2003","v":1068.8433365175706},{"$f":"beløb_4_01/_1_4_2001*_1_8_2003","v":1046.1417828267008},{"$f":"beløb_10_01/_1_10_2001*_1_8_2003","v":1035.6968559406446},{"$f":"beløb_4_02/_1_4_2002*_1_8_2003","v":1025.5415113144168},{"$f":"beløb_4_03/_1_4_2003*_1_8_2003","v":1004.853141250593},{"$f":"Beløb","v":1000},"1/10 '03"]
[null,"1/10-03",{"$f":"Nyt_beløb_1*_1_10_2003","v":1529.7450000000001},{"$f":"Nyt_beløb_2*_1_10_2003","v":1092.675},{"$f":"Nyt_beløb_3*_1_10_2003","v":1092.675},{"$f":"Nyt_beløb_4*_1_10_2003","v":1092.675},{"$f":"beløb_4_00/_1_4_2000*_1_10_2003","v":1072.7655442640043},{"$f":"beløb_4_01/_1_4_2001*_1_10_2003","v":1049.9806853714272},{"$f":"beløb_4_01/_1_4_2001*_1_10_2003","v":1049.9806853714272},{"$f":"beløb_4_02/_1_4_2002*_1_10_2003","v":1029.3048194836686},{"$f":"beløb_4_03/_1_4_2003*_1_10_2003","v":1008.5405317595545},{"$f":"beløb_8_03/_1_8_2003*_1_10_2003","v":1003.6695815115553},{"$f":"Beløb","v":1000},"1/4 '04"]
[null,"1/4 '04",{"$f":"Nyt_beløb_1*_1_4_2004","v":1553.3322000000001},{"$f":"Nyt_beløb_2*_1_4_2004","v":1109.5230000000001},{"$f":"Nyt_beløb_3*_1_4_2004","v":1109.5230000000001},{"$f":"Nyt_beløb_4*_1_4_2004","v":1109.5230000000001},{"$f":"beløb_4_00/_1_4_2000*_1_4_2004","v":1089.3065595611056},{"$f":"beløb_4_01/_1_4_2001*_1_4_2004","v":1066.1703800081104},{"$f":"beløb_4_01/_1_4_2001*_1_4_2004","v":1066.1703800081104},{"$f":"beløb_4_02/_1_4_2002*_1_4_2004","v":1045.1757121083381},{"$f":"beløb_4_03/_1_4_2003*_1_4_2004","v":1024.091258992341},{"$f":"beløb_8_03/_1_8_2003*_1_4_2004","v":1019.1452033655436},{"$f":"beløb_10_03/_1_10_2003*_1_4_2004","v":1015.4190404283066},{"$f":"Beløb","v":1000},"1/8 '04"]
[null,"1/8 '04",{"$f":"Nyt_beløb_1*_1_8_2004","v":1568.0532000000001},{"$f":"Nyt_beløb_2*_1_8_2004","v":1120.038},{"$f":"Nyt_beløb_3*_1_8_2004","v":1120.038},{"$f":"Nyt_beløb_4*_1_8_2004","v":1120.038},{"$f":"beløb_4_00/_1_4_2000*_1_8_2004","v":1099.6299674343854},{"$f":"beløb_4_01/_1_4_2001*_1_8_2004","v":1076.2745252541172},{"$f":"beløb_4_01/_1_4_2001*_1_8_2004","v":1076.2745252541172},{"$f":"beløb_4_02/_1_4_2002*_1_8_2004","v":1055.0808899305366},{"$f":"beløb_4_03/_1_4_2003*_1_8_2004","v":1033.7966184921481},{"$f":"beløb_8_03/_1_8_2003*_1_8_2004","v":1028.8036888709262},{"$f":"beløb_10_03/_1_10_2003*_1_8_2004","v":1025.0422129178392},{"$f":"beløb_4_04/_1_4_2004*_1_8_2004","v":1009.4770455411921},{"$f":"Beløb","v":1000},"1/10 '04"]
[null,"1/10 '04",{"$f":"Nyt_beløb_1*_1_10_2004","v":1574.2356},{"$f":"Nyt_beløb_2*_1_10_2004","v":1124.4540000000002},{"$f":"Nyt_beløb_3*_1_10_2004","v":1124.4540000000002},{"$f":"Nyt_beløb_4*_1_10_2004","v":1124.4540000000002},{"$f":"beløb_4_00/_1_4_2000*_1_10_2004","v":1103.9655042074146},{"$f":"beløb_4_01/_1_4_2001*_1_10_2004","v":1080.5179779794016},{"$f":"beløb_4_01/_1_4_2001*_1_10_2004","v":1080.5179779794016},{"$f":"beløb_4_02/_1_4_2002*_1_10_2004","v":1059.2407820144956},{"$f":"beløb_4_03/_1_4_2003*_1_10_2004","v":1037.8725925816534},{"$f":"beløb_8_03/_1_8_2003*_1_10_2004","v":1032.8599772201198},{"$f":"beløb_10_03/_1_10_2003*_1_10_2004","v":1029.0836708078798},{"$f":"beløb_4_04/_1_4_2004*_1_10_2004","v":1013.4571342820293},{"$f":"beløb_8_04/_1_8_2004*_1_10_2004","v":1003.9427233718856},{"$f":"Beløb","v":1000}]

{"sheet":"Tillæg_trin","index":6,"n_rows":16,"n_cols":4,"rows_kept":16,"cut":false,"hidden":true,"merged":[[1,1,1,7]]}
[3]
[]
[null,"Valgt lønniveau: ",{"$f":"Forside!K11","v":"2022-04-01"}]
[]
[null,"Løngruppe",null,3]
[null,"Timer/uge",null,37]
[null,"Pensions-% inkl. evt. fritvalgs-%",null,13.89]
[null,"Særlig feriegodtgørelse, aktuel pct.",null,1.95]
[]
[null,"Stigning:","Fra","Til"]
[null,"Løntrin ",18,19]
[]
[null,"Løn",{"$f":"(VLOOKUP(til_trin,Lønark!A5:F61,løngruppe+2,FALSE)-VLOOKUP(fra_trin,Lønark!A5:F61,løngruppe+2,FALSE))/37*timetal*12","v":4143.9999999999854}]
[null,"Pension inkl. evt. fritvalgstillæg",{"$f":"(VLOOKUP(til_trin,Lønark!L5:Q61,løngruppe+2,FALSE)-VLOOKUP(fra_trin,Lønark!L5:Q61,løngruppe+2,FALSE))/37*timetal*pensionsstatus%*12","v":575.60159999999792}]
[null,"Ferietillæg",{"$f":"ferie_pct%*C13","v":80.807999999999723}]
[null,"Årlig bruttoudgift i alt",{"$f":"ROUND(SUM(C13:C15),0)","v":4800}]

{"sheet":"Tillæg_kr","index":7,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":true,"merged":[[9,1,9,2]]}
[2]
[]
[null,null,"Valgt lønniveau:",{"$f":"Forside!K11","v":"2022-04-01"}]
[]
[{"$f":"VLOOKUP(dummy,reg_procenter,2,FALSE)","v":{"$error":"#NAME?"}},null,"Årligt beløb, 31.3.2000 niveau ",12900]
[null,null,"Timer/uge",30]
[null,null,"Pension-% inkl. evt. fritvalgs-%",13.89]
[null,null,"Særlig feriegodtg., aktuel pct.",1.95]
[]
[]
[null,null,"bruttoudgift / år","bruttoudgift / md"]
[null,"Løn",{"$f":"kr*valgt_regulering/37*timetal","v":15238.731648648649},{"$f":"beløb/12","v":1269.8943040540541}]
[null,"Pension inkl. evt. fritvalgstillæg",{"$f":"beløb*pensionsstatus%","v":2116.659825997297},{"$f":"C13/12","v":176.38831883310809}]
[null,"Ferietillæg",{"$f":"D8%*(C12)","v":297.15526714864865},{"$f":"C14/12","v":24.762938929054055}]
[null,"Bruttoudgift i alt",{"$f":"ROUND(SUM(C12:C14),0)","v":17653},{"$f":"ROUND(SUM(D12:D14),0)","v":1471}]

{"sheet":"Samlet_omk","index":8,"n_rows":26,"n_cols":3,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[2,"Valgt lønniveau: ",{"$f":"Forside!K11","v":"2022-04-01"}]
[]
[null,"Løngruppe",0]
[null,"Timer/uge",37]
[null,"Pensions-% inkl. evt. fritvalgs-%",13.89]
[null,"Særlig feriegodtgørelse, aktuel pct.",1.95]
[]
[null,"Løntrin ",21]
[]
[null,"Reguleret tillæg (31.3.2000) kr./år",12000]
[]
[]
[null,"Løn/time",{"$f":"IFERROR(ROUND(VLOOKUP(fra_trin,Lønark!A5:AU61,løngruppe+43,FALSE)/1924,2)+ROUND(C10*valgt_regulering/1924,2),ROUND(C10*valgt_regulering/1924,2))","v":163.52000000000001}]
[null,"Pension inkl. evt. fritvalgstillæg",{"$f":"C13*pensionsstatus%","v":22.712928000000002}]
[null,"Ferietillæg",{"$f":"C6%*C13","v":3.1886400000000004}]
[null,"Time bruttoudgift i alt",{"$f":"SUM(C13:C15)","v":189.42156800000001}]
[]
[null,"Løn/måned",{"$f":"IFERROR((VLOOKUP(fra_trin,Lønark!A5:F61,løngruppe+2,FALSE)+(C10*valgt_regulering/12))/37*timetal,C10*valgt_regulering/12/37*timetal)","v":26217.349666666669}]
[null,"Pension inkl. evt. fritvalgstillæg",{"$f":"IFERROR(((VLOOKUP(fra_trin,Lønark!L5:Q61,løngruppe+2,FALSE)+C10/12*valgt_regulering)/37*timetal)*pensionsstatus%,C10/12*valgt_regulering/37*timetal*pensionsstatus%)","v":3641.5898687000004}]
[null,"Ferietillæg",{"$f":"C6%*C18","v":511.23831850000005}]
[null,"Månedlig bruttoudgift i alt",{"$f":"SUM(C18:C20)","v":30370.177853866669}]
[]
[null,"Løn/år",{"$f":"C18*12","v":314608.196}]
[null,"Pension inkl. evt. fritvalgstillæg",{"$f":"C19*12","v":43699.078424400002}]
[null,"Ferietillæg",{"$f":"C20*12","v":6134.8598220000003}]
[null,"Årlig bruttoudgift i alt",{"$f":"SUM(C23:C25)","v":364442.13424640003}]

{"sheet":"Tid op_ned","index":9,"n_rows":31,"n_cols":8,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[2,"Valgt lønniveau: ",{"$f":"Forside!K11","v":"2022-04-01"}]
[]
[null,"Grundoplysninger:"]
[null,"Løngruppe",0]
[null,"Pensions-% inkl. evt. fritvalgs-%",12.94]
[null,"Særlig feriegodtgørelse, aktuel procent",1.95]
[]
[]
[null,"Lønsammensætning (trin i alt og grundbeløb i alt)","Før ændring",null,"Efter ændring"]
[]
[null,"Løndele:","I alt"]
[]
[null,"Løntrin - centralt og lokalt aftalte",33,null,33]
[]
[null,"Tillæg (grundbeløb 31.3.2000) kr./år centralt og lokalt aftalte",null,null,11300]
[]
[]
[null,null,"Før ændring",null,"Efter ændring",null,null,"Difference"]
[null,"Timer/uge",32,null,32,null,null,{"$f":"-(C19-timetal_ny)","v":0}]
[]
[null,"Fast månedsløn",{"$f":"(VLOOKUP(C13,Lønark!A5:F61,$C$4+2,FALSE)+((C15)*valgt_regulering/12))/37*C19","v":25958.630630630632},null,{"$f":"(VLOOKUP(E13,Lønark!A5:F61,$C$4+2,FALSE)+((E15)*valgt_regulering/12))/37*timetal_ny","v":27145.177866666669},null,null,{"$f":"E21-C21","v":1186.5472360360363}]
[null,"Pension inkl. evt. fritvalgstillæg",{"$f":"(((VLOOKUP(C13,Lønark!L5:Q61,løngruppe+2,FALSE)+(C15*valgt_regulering/12))/37*C19)*C5%)","v":3433.711769369369},null,{"$f":"((VLOOKUP(E13,Lønark!L5:Q61,løngruppe+2,FALSE)+(E15*valgt_regulering/12))/37*timetal_ny)*C5%","v":3587.2509817124323},null,null,{"$f":"E22-C22","v":153.53921234306335}]
[null,"Ferietillæg",{"$f":"$C$6%*C21","v":506.19329729729731},null,{"$f":"$C$6%*E21","v":529.33096840000007},null,null,{"$f":"E23-C23","v":23.137671102702768}]
[null,"Månedsløn, brutto",{"$f":"SUM(C21:C23)","v":29898.535697297299},null,{"$f":"SUM(E21:E23)","v":31261.759816779104},null,null,{"$f":"E24-C24","v":1363.2241194818052}]
[]
[null,"Fast løn, år",{"$f":"C21*12","v":311503.56756756757},0,325742.13440000004,null,null,{"$f":"E26-C26","v":14238.566832432465}]
[null,"Pension inkl. evt. fritvalgstillæg, år",41204.541232432428,0,43047.01178054919,null,null,{"$f":"E27-C27","v":1842.4705481167621}]
[null,"Ferietillæg, år",{"$f":"C23*12","v":6074.3195675675679},null,{"$f":"E23*12","v":6351.9716208000009},null,null,{"$f":"E28-C28","v":277.65205323243299}]
[null,"Årsløn, brutto",{"$f":"SUM(C26:C28)","v":358782.42836756754},null,{"$f":"SUM(E26:E28)","v":375141.1178013492},null,null,{"$f":"E29-C29","v":16358.689433781663}]
[]
[null,"Timeløn",{"$f":"ROUND(VLOOKUP(C13,Lønark!A5:AU61,C4+43,FALSE)/1924,2)+ROUND(C15*valgt_regulering/1924,2)","v":187.2},{"$f":"D26/timetal_ny*37/1924","v":0},{"$f":"ROUND(VLOOKUP(E13,Lønark!A5:AU61,C4+43,FALSE)/1924,2)+ROUND(E15*valgt_regulering/1924,2)","v":195.76},null,null,{"$f":"E31-C31","v":8.5600000000000023}]